{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "87f8cb48",
   "metadata": {},
   "source": [
    "\n",
    "第一题:使用Python处理数据，使用matlab对数据进行探索性分析"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "c1cd39dd",
   "metadata": {},
   "outputs": [],
   "source": [
    "#导入库\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "380a1e60",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(21161, 7)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#导入原始数据\n",
    "filepath = 'D:\\\\yanyi\\\\data\\\\other.csv'\n",
    "df = pd.read_csv(filepath,encoding=\"utf-8\")\n",
    "data = np.array(df)\n",
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "53c374be",
   "metadata": {},
   "outputs": [],
   "source": [
    "#对 nan数据进行处理\n",
    "for i in range(21161):\n",
    "        if(np.isnan(data[i][6]) == True):\n",
    "            data[i][6] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "df33e164",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['AFG', 'Afghanistan', 1949, ..., 0.002, 7624058.0, 0],\n",
       "       ['AFG', 'Afghanistan', 1950, ..., 0.011, 7752117.0, 9421400064.0],\n",
       "       ['AFG', 'Afghanistan', 1951, ..., 0.012, 7840151.0, 9692279808.0],\n",
       "       ...,\n",
       "       ['ZWE', 'Zimbabwe', 2018, ..., 0.821, 14438812.0, 22715353088.0],\n",
       "       ['ZWE', 'Zimbabwe', 2019, ..., 0.748, 14645473.0, 0],\n",
       "       ['ZWE', 'Zimbabwe', 2020, ..., 0.709, 14862927.0, 0]], dtype=object)"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "964e44f7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(21161,)"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#输出year\n",
    "year = np.array(data[:,2])\n",
    "year.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1dc6c8d3",
   "metadata": {},
   "source": [
    "一步一步来，步骤：(1)看年份最久的是谁，以年份最长的作为一个数组存下来； （记录有多少个国家）(2)以数据年份遍历，当遇到对应年份时，把co2，gdp累加(3)最后再取平均  (4)存入excel表 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "a4c6e639",
   "metadata": {},
   "outputs": [],
   "source": [
    "#对数据整合\n",
    "total = np.zeros(shape=(101,5))   #总的数组 每个\n",
    "for year_temp in range(1920,2021):\n",
    "    for i in range(len(year)):\n",
    "        if(year[i] == year_temp):\n",
    "            total[year_temp-1920][0] +=1;\n",
    "            total[year_temp-1920][1] +=data[i][3];\n",
    "            total[year_temp-1920][2] +=data[i][4];\n",
    "            total[year_temp-1920][3] +=data[i][5];\n",
    "            total[year_temp-1920][4] +=data[i][6];"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "cfbdca70",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[6.80000000e+01, 1.38920940e+04, 7.67890000e+01, 5.09306649e+09,\n",
       "        5.01953178e+12],\n",
       "       [6.90000000e+01, 1.23832210e+04, 7.39460000e+01, 5.13469321e+09,\n",
       "        6.43489306e+11],\n",
       "       [6.90000000e+01, 1.31202450e+04, 7.58560000e+01, 5.17789938e+09,\n",
       "        6.68135729e+11],\n",
       "       [6.90000000e+01, 1.43159440e+04, 8.10480000e+01, 5.22291394e+09,\n",
       "        6.85599207e+11],\n",
       "       [6.90000000e+01, 1.47762040e+04, 8.33740000e+01, 5.26861032e+09,\n",
       "        7.50876276e+11],\n",
       "       [6.90000000e+01, 1.48523800e+04, 8.33500000e+01, 5.31501848e+09,\n",
       "        7.70148316e+11],\n",
       "       [7.30000000e+01, 1.42341430e+04, 8.35770000e+01, 5.36207106e+09,\n",
       "        8.02400795e+11],\n",
       "       [7.50000000e+01, 1.60124860e+04, 8.96250000e+01, 5.41776409e+09,\n",
       "        8.16506397e+11],\n",
       "       [7.90000000e+01, 1.59973140e+04, 9.31200000e+01, 5.48834338e+09,\n",
       "        8.55290587e+11],\n",
       "       [7.90000000e+01, 1.72111300e+04, 9.84730000e+01, 5.53914395e+09,\n",
       "        1.47104788e+12],\n",
       "       [7.90000000e+01, 1.60251200e+04, 1.04684000e+02, 5.59880902e+09,\n",
       "        1.46622176e+12],\n",
       "       [8.20000000e+01, 1.45215000e+04, 8.74340000e+01, 5.66383950e+09,\n",
       "        1.46656901e+12],\n",
       "       [8.30000000e+01, 1.32531740e+04, 8.48650000e+01, 5.72328386e+09,\n",
       "        1.45026560e+12],\n",
       "       [8.70000000e+01, 1.39032000e+04, 9.03340000e+01, 5.78726038e+09,\n",
       "        1.42067844e+12],\n",
       "       [8.70000000e+01, 1.51883210e+04, 1.03614000e+02, 5.84776364e+09,\n",
       "        1.45726966e+12],\n",
       "       [8.70000000e+01, 1.59753070e+04, 1.13560000e+02, 5.90902658e+09,\n",
       "        1.51530658e+12],\n",
       "       [8.80000000e+01, 1.74279130e+04, 1.35752000e+02, 5.97398186e+09,\n",
       "        1.62011464e+12],\n",
       "       [8.80000000e+01, 1.86903460e+04, 1.60925000e+02, 6.03715144e+09,\n",
       "        1.63356033e+12],\n",
       "       [8.90000000e+01, 1.79592180e+04, 1.63229000e+02, 6.10276631e+09,\n",
       "        1.68497717e+12],\n",
       "       [9.00000000e+01, 1.88311670e+04, 2.26411000e+02, 6.16475421e+09,\n",
       "        1.05031152e+12],\n",
       "       [9.00000000e+01, 2.06056940e+04, 2.53383000e+02, 6.22935148e+09,\n",
       "        8.06936774e+12],\n",
       "       [9.30000000e+01, 2.06973780e+04, 2.11807000e+02, 6.29999243e+09,\n",
       "        1.07593762e+12],\n",
       "       [9.30000000e+01, 2.01311070e+04, 1.78874000e+02, 6.34950217e+09,\n",
       "        9.36351836e+11],\n",
       "       [9.40000000e+01, 2.04480510e+04, 1.94642000e+02, 6.39604975e+09,\n",
       "        9.10111561e+11],\n",
       "       [9.40000000e+01, 2.05754000e+04, 2.18395000e+02, 6.44150830e+09,\n",
       "        8.99924644e+11],\n",
       "       [9.40000000e+01, 1.64347290e+04, 1.72266000e+02, 6.48638017e+09,\n",
       "        8.95284431e+11],\n",
       "       [9.70000000e+01, 1.85829210e+04, 2.23086000e+02, 6.60208878e+09,\n",
       "        9.67490749e+11],\n",
       "       [9.80000000e+01, 2.07692670e+04, 3.60967000e+02, 6.65349028e+09,\n",
       "        9.39573387e+11],\n",
       "       [9.90000000e+01, 2.19294720e+04, 2.04541000e+02, 6.70832705e+09,\n",
       "        1.11367327e+12],\n",
       "       [1.02000000e+02, 2.20207130e+04, 4.73139000e+02, 6.78628084e+09,\n",
       "        1.24790094e+12],\n",
       "       [1.61000000e+02, 2.45915560e+04, 8.09013000e+02, 6.98138476e+09,\n",
       "        1.07705687e+13],\n",
       "       [1.63000000e+02, 2.62154800e+04, 1.06736300e+03, 7.11766071e+09,\n",
       "        2.55232219e+12],\n",
       "       [1.65000000e+02, 2.67750580e+04, 6.85618000e+02, 7.25144048e+09,\n",
       "        2.72637022e+12],\n",
       "       [1.65000000e+02, 2.75875140e+04, 7.34725000e+02, 7.38450186e+09,\n",
       "        2.92724250e+12],\n",
       "       [1.66000000e+02, 2.85608730e+04, 1.22906600e+03, 7.51893649e+09,\n",
       "        2.98679306e+12],\n",
       "       [1.70000000e+02, 3.13084560e+04, 1.05251900e+03, 7.66276958e+09,\n",
       "        3.16527083e+12],\n",
       "       [1.70000000e+02, 3.34171750e+04, 1.24948000e+03, 7.80334547e+09,\n",
       "        3.32776167e+12],\n",
       "       [1.72000000e+02, 3.47330940e+04, 9.29592000e+02, 7.94815001e+09,\n",
       "        3.47855138e+12],\n",
       "       [1.78000000e+02, 3.59503400e+04, 8.33717000e+02, 8.11730852e+09,\n",
       "        3.62571971e+12],\n",
       "       [1.86000000e+02, 3.77816200e+04, 9.52980000e+02, 8.28353270e+09,\n",
       "        3.74324869e+12],\n",
       "       [1.86000000e+02, 4.01527930e+04, 8.51024000e+02, 8.44249982e+09,\n",
       "        1.77595917e+13],\n",
       "       [1.87000000e+02, 4.04730160e+04, 8.66826000e+02, 8.60514592e+09,\n",
       "        4.64076609e+12],\n",
       "       [1.90000000e+02, 4.20312080e+04, 8.95846000e+02, 8.77326911e+09,\n",
       "        4.86765110e+12],\n",
       "       [1.91000000e+02, 4.43949340e+04, 9.43096000e+02, 8.94739036e+09,\n",
       "        5.16066746e+12],\n",
       "       [1.93000000e+02, 4.68421800e+04, 9.45463000e+02, 9.12939098e+09,\n",
       "        5.55478171e+12],\n",
       "       [1.93000000e+02, 4.89221450e+04, 8.98195000e+02, 9.31885568e+09,\n",
       "        5.83835079e+12],\n",
       "       [1.93000000e+02, 5.12353580e+04, 8.55920000e+02, 9.51674928e+09,\n",
       "        6.12295251e+12],\n",
       "       [1.93000000e+02, 5.28090180e+04, 9.19397000e+02, 9.72238538e+09,\n",
       "        6.37860791e+12],\n",
       "       [1.94000000e+02, 5.56937350e+04, 8.99612000e+02, 9.93412252e+09,\n",
       "        6.68334879e+12],\n",
       "       [1.95000000e+02, 5.93753730e+04, 1.08526600e+03, 1.01496789e+10,\n",
       "        7.13845545e+12],\n",
       "       [1.98000000e+02, 6.40650670e+04, 1.16192900e+03, 1.03680174e+10,\n",
       "        2.95995819e+13],\n",
       "       [1.99000000e+02, 6.68684860e+04, 1.15146600e+03, 1.05868367e+10,\n",
       "        8.23403881e+12],\n",
       "       [2.00000000e+02, 6.99041160e+04, 1.14247400e+03, 1.08084002e+10,\n",
       "        8.62078873e+12],\n",
       "       [2.00000000e+02, 7.36146050e+04, 1.21680000e+03, 1.10301261e+10,\n",
       "        1.02929410e+13],\n",
       "       [2.00000000e+02, 7.37335470e+04, 1.12481800e+03, 1.12517285e+10,\n",
       "        9.71904584e+12],\n",
       "       [2.00000000e+02, 7.43753350e+04, 1.02719700e+03, 1.14726666e+10,\n",
       "        1.01400552e+13],\n",
       "       [2.00000000e+02, 7.85639770e+04, 1.24314100e+03, 1.16924487e+10,\n",
       "        1.06101913e+13],\n",
       "       [2.00000000e+02, 8.06975550e+04, 1.06256200e+03, 1.19114901e+10,\n",
       "        1.11351322e+13],\n",
       "       [2.00000000e+02, 8.33693560e+04, 1.02481800e+03, 1.21313355e+10,\n",
       "        1.16990501e+13],\n",
       "       [2.00000000e+02, 8.57675380e+04, 1.03322300e+03, 1.23541600e+10,\n",
       "        1.21622776e+13],\n",
       "       [2.00000000e+02, 8.56763030e+04, 1.02014400e+03, 1.25821704e+10,\n",
       "        4.57178727e+13],\n",
       "       [2.01000000e+02, 8.36133820e+04, 9.35247000e+02, 1.28136717e+10,\n",
       "        1.41234976e+13],\n",
       "       [2.01000000e+02, 8.33778390e+04, 9.32623000e+02, 1.30499062e+10,\n",
       "        1.45073355e+13],\n",
       "       [2.01000000e+02, 8.40237330e+04, 8.14916000e+02, 1.32915275e+10,\n",
       "        1.49264316e+13],\n",
       "       [2.01000000e+02, 8.65571590e+04, 9.58205000e+02, 1.35399005e+10,\n",
       "        1.55857531e+13],\n",
       "       [2.01000000e+02, 8.98928980e+04, 1.01006300e+03, 1.37956199e+10,\n",
       "        1.61235607e+13],\n",
       "       [2.01000000e+02, 9.11347600e+04, 8.05310000e+02, 1.40594786e+10,\n",
       "        1.67225577e+13],\n",
       "       [2.02000000e+02, 9.33666090e+04, 7.97122000e+02, 1.43301787e+10,\n",
       "        1.74045017e+13],\n",
       "       [2.02000000e+02, 9.66616770e+04, 8.26576000e+02, 1.46036198e+10,\n",
       "        1.81003068e+13],\n",
       "       [2.02000000e+02, 9.77076340e+04, 8.74731000e+02, 1.48742570e+10,\n",
       "        1.85516795e+13],\n",
       "       [2.15000000e+02, 9.94163180e+04, 8.76915000e+02, 1.51449859e+10,\n",
       "        6.18682175e+13],\n",
       "       [2.16000000e+02, 1.00039767e+05, 8.44982000e+02, 1.54000293e+10,\n",
       "        1.92225144e+13],\n",
       "       [2.16000000e+02, 9.71471470e+04, 8.26994000e+02, 1.56482299e+10,\n",
       "        1.96837834e+13],\n",
       "       [2.16000000e+02, 9.75752390e+04, 8.59780000e+02, 1.58904867e+10,\n",
       "        2.05200077e+13],\n",
       "       [2.16000000e+02, 9.74165980e+04, 8.43906000e+02, 1.61293812e+10,\n",
       "        2.12875060e+13],\n",
       "       [2.16000000e+02, 9.91726710e+04, 8.41008000e+02, 1.63668846e+10,\n",
       "        2.23622657e+13],\n",
       "       [2.16000000e+02, 1.01826463e+05, 8.43043000e+02, 1.66033458e+10,\n",
       "        2.36257401e+13],\n",
       "       [2.16000000e+02, 1.01989786e+05, 8.51274000e+02, 1.68383119e+10,\n",
       "        2.47088276e+13],\n",
       "       [2.16000000e+02, 1.01274731e+05, 7.86587000e+02, 1.70720858e+10,\n",
       "        2.50684782e+13],\n",
       "       [2.16000000e+02, 1.02393698e+05, 7.97113000e+02, 1.73048884e+10,\n",
       "        2.60274640e+13],\n",
       "       [2.16000000e+02, 1.05306051e+05, 8.86811000e+02, 1.75375634e+10,\n",
       "        8.75587418e+13],\n",
       "       [2.17000000e+02, 1.06558474e+05, 8.97293000e+02, 1.77692088e+10,\n",
       "        2.88600846e+13],\n",
       "       [2.17000000e+02, 1.08859662e+05, 9.05153000e+02, 1.80007862e+10,\n",
       "        3.03926592e+13],\n",
       "       [2.17000000e+02, 1.14500047e+05, 9.29962000e+02, 1.82330493e+10,\n",
       "        3.22855449e+13],\n",
       "       [2.17000000e+02, 1.19602929e+05, 9.47899000e+02, 1.84668741e+10,\n",
       "        3.48685764e+13],\n",
       "       [2.17000000e+02, 1.23555101e+05, 9.56424000e+02, 1.87028958e+10,\n",
       "        3.75048653e+13],\n",
       "       [2.17000000e+02, 1.27845685e+05, 9.68994000e+02, 1.89413701e+10,\n",
       "        4.06350533e+13],\n",
       "       [2.17000000e+02, 1.31362520e+05, 9.89627000e+02, 1.91821997e+10,\n",
       "        4.39690384e+13],\n",
       "       [2.18000000e+02, 1.33931285e+05, 9.79511000e+02, 1.94251949e+10,\n",
       "        4.62905060e+13],\n",
       "       [2.18000000e+02, 1.31977693e+05, 9.38740000e+02, 1.96699888e+10,\n",
       "        4.76736771e+13],\n",
       "       [2.18000000e+02, 1.39236266e+05, 9.46235000e+02, 1.99162274e+10,\n",
       "        1.41394330e+14],\n",
       "       [2.18000000e+02, 1.44045819e+05, 9.62432000e+02, 2.01637725e+10,\n",
       "        5.46945551e+13],\n",
       "       [2.18000000e+02, 1.46435473e+05, 9.66911000e+02, 2.04124546e+10,\n",
       "        5.69976064e+13],\n",
       "       [2.18000000e+02, 1.47247002e+05, 9.47368000e+02, 2.06617880e+10,\n",
       "        5.94728976e+13],\n",
       "       [2.18000000e+02, 1.48076691e+05, 9.57428000e+02, 2.09111807e+10,\n",
       "        6.19435535e+13],\n",
       "       [2.18000000e+02, 1.48187476e+05, 9.49201000e+02, 2.11600948e+10,\n",
       "        6.39796606e+13],\n",
       "       [2.18000000e+02, 1.48257158e+05, 9.37633000e+02, 2.14082730e+10,\n",
       "        1.72366548e+14],\n",
       "       [2.18000000e+02, 1.50360684e+05, 9.38406000e+02, 2.16554289e+10,\n",
       "        1.77464844e+14],\n",
       "       [2.18000000e+02, 1.53170659e+05, 9.36556000e+02, 2.19003158e+10,\n",
       "        1.83812811e+14],\n",
       "       [2.17000000e+02, 1.53485014e+05, 9.54832000e+02, 2.21435563e+10,\n",
       "        0.00000000e+00],\n",
       "       [2.17000000e+02, 1.46039012e+05, 8.90629000e+02, 2.23839780e+10,\n",
       "        0.00000000e+00]])"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "9f7b3ffe",
   "metadata": {},
   "outputs": [],
   "source": [
    "#取平均\n",
    "for i in range(len(total)):\n",
    "    for j in range(1,5):\n",
    "        total[i][j] = total[i][j]/total[i][0]    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "57428ea7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[6.80000000e+01, 2.04295500e+02, 1.12925000e+00, 7.48980367e+07,\n",
       "        7.38166438e+10],\n",
       "       [6.90000000e+01, 1.79466971e+02, 1.07168116e+00, 7.44158437e+07,\n",
       "        9.32593198e+09],\n",
       "       [6.90000000e+01, 1.90148478e+02, 1.09936232e+00, 7.50420201e+07,\n",
       "        9.68312651e+09],\n",
       "       [6.90000000e+01, 2.07477449e+02, 1.17460870e+00, 7.56944049e+07,\n",
       "        9.93622039e+09],\n",
       "       [6.90000000e+01, 2.14147884e+02, 1.20831884e+00, 7.63566712e+07,\n",
       "        1.08822649e+10],\n",
       "       [6.90000000e+01, 2.15251884e+02, 1.20797101e+00, 7.70292533e+07,\n",
       "        1.11615698e+10],\n",
       "       [7.30000000e+01, 1.94988260e+02, 1.14489041e+00, 7.34530282e+07,\n",
       "        1.09917917e+10],\n",
       "       [7.50000000e+01, 2.13499813e+02, 1.19500000e+00, 7.22368545e+07,\n",
       "        1.08867520e+10],\n",
       "       [7.90000000e+01, 2.02497646e+02, 1.17873418e+00, 6.94727010e+07,\n",
       "        1.08264631e+10],\n",
       "       [7.90000000e+01, 2.17862405e+02, 1.24649367e+00, 7.01157462e+07,\n",
       "        1.86208592e+10],\n",
       "       [7.90000000e+01, 2.02849620e+02, 1.32511392e+00, 7.08710003e+07,\n",
       "        1.85597691e+10],\n",
       "       [8.20000000e+01, 1.77091463e+02, 1.06626829e+00, 6.90712134e+07,\n",
       "        1.78849879e+10],\n",
       "       [8.30000000e+01, 1.59676795e+02, 1.02246988e+00, 6.89552272e+07,\n",
       "        1.74730795e+10],\n",
       "       [8.70000000e+01, 1.59806897e+02, 1.03832184e+00, 6.65202342e+07,\n",
       "        1.63296372e+10],\n",
       "       [8.70000000e+01, 1.74578402e+02, 1.19096552e+00, 6.72156740e+07,\n",
       "        1.67502260e+10],\n",
       "       [8.70000000e+01, 1.83624218e+02, 1.30528736e+00, 6.79198458e+07,\n",
       "        1.74173170e+10],\n",
       "       [8.80000000e+01, 1.98044466e+02, 1.54263636e+00, 6.78861575e+07,\n",
       "        1.84103937e+10],\n",
       "       [8.80000000e+01, 2.12390295e+02, 1.82869318e+00, 6.86039936e+07,\n",
       "        1.85631856e+10],\n",
       "       [8.90000000e+01, 2.01788966e+02, 1.83403371e+00, 6.85704080e+07,\n",
       "        1.89323278e+10],\n",
       "       [9.00000000e+01, 2.09235189e+02, 2.51567778e+00, 6.84972690e+07,\n",
       "        1.16701280e+10],\n",
       "       [9.00000000e+01, 2.28952156e+02, 2.81536667e+00, 6.92150165e+07,\n",
       "        8.96596415e+10],\n",
       "       [9.30000000e+01, 2.22552452e+02, 2.27749462e+00, 6.77418541e+07,\n",
       "        1.15692218e+10],\n",
       "       [9.30000000e+01, 2.16463516e+02, 1.92337634e+00, 6.82742169e+07,\n",
       "        1.00682993e+10],\n",
       "       [9.40000000e+01, 2.17532457e+02, 2.07065957e+00, 6.80430825e+07,\n",
       "        9.68203788e+09],\n",
       "       [9.40000000e+01, 2.18887234e+02, 2.32335106e+00, 6.85266841e+07,\n",
       "        9.57366642e+09],\n",
       "       [9.40000000e+01, 1.74837543e+02, 1.83261702e+00, 6.90040443e+07,\n",
       "        9.52430246e+09],\n",
       "       [9.70000000e+01, 1.91576505e+02, 2.29985567e+00, 6.80627709e+07,\n",
       "        9.97413144e+09],\n",
       "       [9.80000000e+01, 2.11931296e+02, 3.68333673e+00, 6.78927580e+07,\n",
       "        9.58748354e+09],\n",
       "       [9.90000000e+01, 2.21509818e+02, 2.06607071e+00, 6.77608793e+07,\n",
       "        1.12492249e+10],\n",
       "       [1.02000000e+02, 2.15889343e+02, 4.63861765e+00, 6.65321651e+07,\n",
       "        1.22343229e+10],\n",
       "       [1.61000000e+02, 1.52742584e+02, 5.02492547e+00, 4.33626383e+07,\n",
       "        6.68979420e+10],\n",
       "       [1.63000000e+02, 1.60831166e+02, 6.54823926e+00, 4.36666301e+07,\n",
       "        1.56584183e+10],\n",
       "       [1.65000000e+02, 1.62273079e+02, 4.15526061e+00, 4.39481241e+07,\n",
       "        1.65234559e+10],\n",
       "       [1.65000000e+02, 1.67197055e+02, 4.45287879e+00, 4.47545568e+07,\n",
       "        1.77408637e+10],\n",
       "       [1.66000000e+02, 1.72053452e+02, 7.40401205e+00, 4.52947981e+07,\n",
       "        1.79927293e+10],\n",
       "       [1.70000000e+02, 1.84167388e+02, 6.19128824e+00, 4.50751152e+07,\n",
       "        1.86192402e+10],\n",
       "       [1.70000000e+02, 1.96571618e+02, 7.34988235e+00, 4.59020322e+07,\n",
       "        1.95750687e+10],\n",
       "       [1.72000000e+02, 2.01936593e+02, 5.40460465e+00, 4.62101745e+07,\n",
       "        2.02241359e+10],\n",
       "       [1.78000000e+02, 2.01968202e+02, 4.68380337e+00, 4.56028568e+07,\n",
       "        2.03692118e+10],\n",
       "       [1.86000000e+02, 2.03126989e+02, 5.12354839e+00, 4.45351221e+07,\n",
       "        2.01249930e+10],\n",
       "       [1.86000000e+02, 2.15875231e+02, 4.57539785e+00, 4.53897840e+07,\n",
       "        9.54816760e+10],\n",
       "       [1.87000000e+02, 2.16433241e+02, 4.63543316e+00, 4.60168231e+07,\n",
       "        2.48169310e+10],\n",
       "       [1.90000000e+02, 2.21216884e+02, 4.71497895e+00, 4.61751006e+07,\n",
       "        2.56192163e+10],\n",
       "       [1.91000000e+02, 2.32434209e+02, 4.93767539e+00, 4.68449757e+07,\n",
       "        2.70192014e+10],\n",
       "       [1.93000000e+02, 2.42705596e+02, 4.89877202e+00, 4.73025439e+07,\n",
       "        2.87812524e+10],\n",
       "       [1.93000000e+02, 2.53482617e+02, 4.65386010e+00, 4.82842263e+07,\n",
       "        3.02505222e+10],\n",
       "       [1.93000000e+02, 2.65468176e+02, 4.43481865e+00, 4.93095817e+07,\n",
       "        3.17251426e+10],\n",
       "       [1.93000000e+02, 2.73621855e+02, 4.76371503e+00, 5.03750538e+07,\n",
       "        3.30497819e+10],\n",
       "       [1.94000000e+02, 2.87081108e+02, 4.63717526e+00, 5.12068171e+07,\n",
       "        3.44502515e+10],\n",
       "       [1.95000000e+02, 3.04489092e+02, 5.56546667e+00, 5.20496356e+07,\n",
       "        3.66074639e+10],\n",
       "       [1.98000000e+02, 3.23560944e+02, 5.86832828e+00, 5.23637241e+07,\n",
       "        1.49492838e+11],\n",
       "       [1.99000000e+02, 3.36022543e+02, 5.78626131e+00, 5.32001843e+07,\n",
       "        4.13770794e+10],\n",
       "       [2.00000000e+02, 3.49520580e+02, 5.71237000e+00, 5.40420009e+07,\n",
       "        4.31039436e+10],\n",
       "       [2.00000000e+02, 3.68073025e+02, 6.08400000e+00, 5.51506305e+07,\n",
       "        5.14647052e+10],\n",
       "       [2.00000000e+02, 3.68667735e+02, 5.62409000e+00, 5.62586425e+07,\n",
       "        4.85952292e+10],\n",
       "       [2.00000000e+02, 3.71876675e+02, 5.13598500e+00, 5.73633329e+07,\n",
       "        5.07002760e+10],\n",
       "       [2.00000000e+02, 3.92819885e+02, 6.21570500e+00, 5.84622437e+07,\n",
       "        5.30509564e+10],\n",
       "       [2.00000000e+02, 4.03487775e+02, 5.31281000e+00, 5.95574505e+07,\n",
       "        5.56756612e+10],\n",
       "       [2.00000000e+02, 4.16846780e+02, 5.12409000e+00, 6.06566773e+07,\n",
       "        5.84952506e+10],\n",
       "       [2.00000000e+02, 4.28837690e+02, 5.16611500e+00, 6.17708000e+07,\n",
       "        6.08113882e+10],\n",
       "       [2.00000000e+02, 4.28381515e+02, 5.10072000e+00, 6.29108520e+07,\n",
       "        2.28589363e+11],\n",
       "       [2.01000000e+02, 4.15986975e+02, 4.65297015e+00, 6.37496104e+07,\n",
       "        7.02661572e+10],\n",
       "       [2.01000000e+02, 4.14815119e+02, 4.63991542e+00, 6.49249064e+07,\n",
       "        7.21757985e+10],\n",
       "       [2.01000000e+02, 4.18028522e+02, 4.05430846e+00, 6.61270025e+07,\n",
       "        7.42608540e+10],\n",
       "       [2.01000000e+02, 4.30632632e+02, 4.76718905e+00, 6.73626891e+07,\n",
       "        7.75410602e+10],\n",
       "       [2.01000000e+02, 4.47228348e+02, 5.02518905e+00, 6.86349248e+07,\n",
       "        8.02167197e+10],\n",
       "       [2.01000000e+02, 4.53406766e+02, 4.00651741e+00, 6.99476545e+07,\n",
       "        8.31968047e+10],\n",
       "       [2.02000000e+02, 4.62210936e+02, 3.94614851e+00, 7.09414788e+07,\n",
       "        8.61608996e+10],\n",
       "       [2.02000000e+02, 4.78523153e+02, 4.09196040e+00, 7.22951478e+07,\n",
       "        8.96054790e+10],\n",
       "       [2.02000000e+02, 4.83701158e+02, 4.33035149e+00, 7.36349355e+07,\n",
       "        9.18399976e+10],\n",
       "       [2.15000000e+02, 4.62401479e+02, 4.07867442e+00, 7.04417949e+07,\n",
       "        2.87759151e+11],\n",
       "       [2.16000000e+02, 4.63147069e+02, 3.91195370e+00, 7.12964321e+07,\n",
       "        8.89931221e+10],\n",
       "       [2.16000000e+02, 4.49755310e+02, 3.82867593e+00, 7.24455086e+07,\n",
       "        9.11286270e+10],\n",
       "       [2.16000000e+02, 4.51737218e+02, 3.98046296e+00, 7.35670679e+07,\n",
       "        9.50000355e+10],\n",
       "       [2.16000000e+02, 4.51002769e+02, 3.90697222e+00, 7.46730612e+07,\n",
       "        9.85532687e+10],\n",
       "       [2.16000000e+02, 4.59132736e+02, 3.89355556e+00, 7.57726141e+07,\n",
       "        1.03529008e+11],\n",
       "       [2.16000000e+02, 4.71418810e+02, 3.90297685e+00, 7.68673417e+07,\n",
       "        1.09378426e+11],\n",
       "       [2.16000000e+02, 4.72174935e+02, 3.94108333e+00, 7.79551479e+07,\n",
       "        1.14392720e+11],\n",
       "       [2.16000000e+02, 4.68864495e+02, 3.64160648e+00, 7.90374345e+07,\n",
       "        1.16057769e+11],\n",
       "       [2.16000000e+02, 4.74044898e+02, 3.69033796e+00, 8.01152240e+07,\n",
       "        1.20497518e+11],\n",
       "       [2.16000000e+02, 4.87528014e+02, 4.10560648e+00, 8.11924231e+07,\n",
       "        4.05364545e+11],\n",
       "       [2.17000000e+02, 4.91052876e+02, 4.13499078e+00, 8.18857550e+07,\n",
       "        1.32995781e+11],\n",
       "       [2.17000000e+02, 5.01657429e+02, 4.17121198e+00, 8.29529320e+07,\n",
       "        1.40058338e+11],\n",
       "       [2.17000000e+02, 5.27649986e+02, 4.28553917e+00, 8.40232687e+07,\n",
       "        1.48781313e+11],\n",
       "       [2.17000000e+02, 5.51165571e+02, 4.36819816e+00, 8.51008022e+07,\n",
       "        1.60684684e+11],\n",
       "       [2.17000000e+02, 5.69378346e+02, 4.40748387e+00, 8.61884600e+07,\n",
       "        1.72833481e+11],\n",
       "       [2.17000000e+02, 5.89150622e+02, 4.46541014e+00, 8.72874199e+07,\n",
       "        1.87258310e+11],\n",
       "       [2.17000000e+02, 6.05357235e+02, 4.56049309e+00, 8.83972334e+07,\n",
       "        2.02622297e+11],\n",
       "       [2.18000000e+02, 6.14363693e+02, 4.49316972e+00, 8.91063986e+07,\n",
       "        2.12341770e+11],\n",
       "       [2.18000000e+02, 6.05402261e+02, 4.30614679e+00, 9.02293067e+07,\n",
       "        2.18686592e+11],\n",
       "       [2.18000000e+02, 6.38698468e+02, 4.34052752e+00, 9.13588412e+07,\n",
       "        6.48597844e+11],\n",
       "       [2.18000000e+02, 6.60760638e+02, 4.41482569e+00, 9.24943692e+07,\n",
       "        2.50892455e+11],\n",
       "       [2.18000000e+02, 6.71722353e+02, 4.43537156e+00, 9.36351130e+07,\n",
       "        2.61456910e+11],\n",
       "       [2.18000000e+02, 6.75444963e+02, 4.34572477e+00, 9.47788442e+07,\n",
       "        2.72811457e+11],\n",
       "       [2.18000000e+02, 6.79250876e+02, 4.39187156e+00, 9.59228475e+07,\n",
       "        2.84144741e+11],\n",
       "       [2.18000000e+02, 6.79759064e+02, 4.35413303e+00, 9.70646551e+07,\n",
       "        2.93484682e+11],\n",
       "       [2.18000000e+02, 6.80078706e+02, 4.30106881e+00, 9.82030869e+07,\n",
       "        7.90672240e+11],\n",
       "       [2.18000000e+02, 6.89727908e+02, 4.30461468e+00, 9.93368299e+07,\n",
       "        8.14058917e+11],\n",
       "       [2.18000000e+02, 7.02617702e+02, 4.29612844e+00, 1.00460164e+08,\n",
       "        8.43178034e+11],\n",
       "       [2.17000000e+02, 7.07304212e+02, 4.40014747e+00, 1.02044038e+08,\n",
       "        0.00000000e+00],\n",
       "       [2.17000000e+02, 6.72990839e+02, 4.10428111e+00, 1.03151972e+08,\n",
       "        0.00000000e+00]])"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "70d8a47a",
   "metadata": {},
   "outputs": [],
   "source": [
    "#修改年份\n",
    "year_q = np.arange(1884,2021,1) \n",
    "for i in range(len(total)):\n",
    "    total[i][0] = int(year_q[i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "c463d85e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[1.88400000e+03, 2.04295500e+02, 1.12925000e+00, 7.48980367e+07,\n",
       "        7.38166438e+10],\n",
       "       [1.88500000e+03, 1.79466971e+02, 1.07168116e+00, 7.44158437e+07,\n",
       "        9.32593198e+09],\n",
       "       [1.88600000e+03, 1.90148478e+02, 1.09936232e+00, 7.50420201e+07,\n",
       "        9.68312651e+09],\n",
       "       [1.88700000e+03, 2.07477449e+02, 1.17460870e+00, 7.56944049e+07,\n",
       "        9.93622039e+09],\n",
       "       [1.88800000e+03, 2.14147884e+02, 1.20831884e+00, 7.63566712e+07,\n",
       "        1.08822649e+10],\n",
       "       [1.88900000e+03, 2.15251884e+02, 1.20797101e+00, 7.70292533e+07,\n",
       "        1.11615698e+10],\n",
       "       [1.89000000e+03, 1.94988260e+02, 1.14489041e+00, 7.34530282e+07,\n",
       "        1.09917917e+10],\n",
       "       [1.89100000e+03, 2.13499813e+02, 1.19500000e+00, 7.22368545e+07,\n",
       "        1.08867520e+10],\n",
       "       [1.89200000e+03, 2.02497646e+02, 1.17873418e+00, 6.94727010e+07,\n",
       "        1.08264631e+10],\n",
       "       [1.89300000e+03, 2.17862405e+02, 1.24649367e+00, 7.01157462e+07,\n",
       "        1.86208592e+10],\n",
       "       [1.89400000e+03, 2.02849620e+02, 1.32511392e+00, 7.08710003e+07,\n",
       "        1.85597691e+10],\n",
       "       [1.89500000e+03, 1.77091463e+02, 1.06626829e+00, 6.90712134e+07,\n",
       "        1.78849879e+10],\n",
       "       [1.89600000e+03, 1.59676795e+02, 1.02246988e+00, 6.89552272e+07,\n",
       "        1.74730795e+10],\n",
       "       [1.89700000e+03, 1.59806897e+02, 1.03832184e+00, 6.65202342e+07,\n",
       "        1.63296372e+10],\n",
       "       [1.89800000e+03, 1.74578402e+02, 1.19096552e+00, 6.72156740e+07,\n",
       "        1.67502260e+10],\n",
       "       [1.89900000e+03, 1.83624218e+02, 1.30528736e+00, 6.79198458e+07,\n",
       "        1.74173170e+10],\n",
       "       [1.90000000e+03, 1.98044466e+02, 1.54263636e+00, 6.78861575e+07,\n",
       "        1.84103937e+10],\n",
       "       [1.90100000e+03, 2.12390295e+02, 1.82869318e+00, 6.86039936e+07,\n",
       "        1.85631856e+10],\n",
       "       [1.90200000e+03, 2.01788966e+02, 1.83403371e+00, 6.85704080e+07,\n",
       "        1.89323278e+10],\n",
       "       [1.90300000e+03, 2.09235189e+02, 2.51567778e+00, 6.84972690e+07,\n",
       "        1.16701280e+10],\n",
       "       [1.90400000e+03, 2.28952156e+02, 2.81536667e+00, 6.92150165e+07,\n",
       "        8.96596415e+10],\n",
       "       [1.90500000e+03, 2.22552452e+02, 2.27749462e+00, 6.77418541e+07,\n",
       "        1.15692218e+10],\n",
       "       [1.90600000e+03, 2.16463516e+02, 1.92337634e+00, 6.82742169e+07,\n",
       "        1.00682993e+10],\n",
       "       [1.90700000e+03, 2.17532457e+02, 2.07065957e+00, 6.80430825e+07,\n",
       "        9.68203788e+09],\n",
       "       [1.90800000e+03, 2.18887234e+02, 2.32335106e+00, 6.85266841e+07,\n",
       "        9.57366642e+09],\n",
       "       [1.90900000e+03, 1.74837543e+02, 1.83261702e+00, 6.90040443e+07,\n",
       "        9.52430246e+09],\n",
       "       [1.91000000e+03, 1.91576505e+02, 2.29985567e+00, 6.80627709e+07,\n",
       "        9.97413144e+09],\n",
       "       [1.91100000e+03, 2.11931296e+02, 3.68333673e+00, 6.78927580e+07,\n",
       "        9.58748354e+09],\n",
       "       [1.91200000e+03, 2.21509818e+02, 2.06607071e+00, 6.77608793e+07,\n",
       "        1.12492249e+10],\n",
       "       [1.91300000e+03, 2.15889343e+02, 4.63861765e+00, 6.65321651e+07,\n",
       "        1.22343229e+10],\n",
       "       [1.91400000e+03, 1.52742584e+02, 5.02492547e+00, 4.33626383e+07,\n",
       "        6.68979420e+10],\n",
       "       [1.91500000e+03, 1.60831166e+02, 6.54823926e+00, 4.36666301e+07,\n",
       "        1.56584183e+10],\n",
       "       [1.91600000e+03, 1.62273079e+02, 4.15526061e+00, 4.39481241e+07,\n",
       "        1.65234559e+10],\n",
       "       [1.91700000e+03, 1.67197055e+02, 4.45287879e+00, 4.47545568e+07,\n",
       "        1.77408637e+10],\n",
       "       [1.91800000e+03, 1.72053452e+02, 7.40401205e+00, 4.52947981e+07,\n",
       "        1.79927293e+10],\n",
       "       [1.91900000e+03, 1.84167388e+02, 6.19128824e+00, 4.50751152e+07,\n",
       "        1.86192402e+10],\n",
       "       [1.92000000e+03, 1.96571618e+02, 7.34988235e+00, 4.59020322e+07,\n",
       "        1.95750687e+10],\n",
       "       [1.92100000e+03, 2.01936593e+02, 5.40460465e+00, 4.62101745e+07,\n",
       "        2.02241359e+10],\n",
       "       [1.92200000e+03, 2.01968202e+02, 4.68380337e+00, 4.56028568e+07,\n",
       "        2.03692118e+10],\n",
       "       [1.92300000e+03, 2.03126989e+02, 5.12354839e+00, 4.45351221e+07,\n",
       "        2.01249930e+10],\n",
       "       [1.92400000e+03, 2.15875231e+02, 4.57539785e+00, 4.53897840e+07,\n",
       "        9.54816760e+10],\n",
       "       [1.92500000e+03, 2.16433241e+02, 4.63543316e+00, 4.60168231e+07,\n",
       "        2.48169310e+10],\n",
       "       [1.92600000e+03, 2.21216884e+02, 4.71497895e+00, 4.61751006e+07,\n",
       "        2.56192163e+10],\n",
       "       [1.92700000e+03, 2.32434209e+02, 4.93767539e+00, 4.68449757e+07,\n",
       "        2.70192014e+10],\n",
       "       [1.92800000e+03, 2.42705596e+02, 4.89877202e+00, 4.73025439e+07,\n",
       "        2.87812524e+10],\n",
       "       [1.92900000e+03, 2.53482617e+02, 4.65386010e+00, 4.82842263e+07,\n",
       "        3.02505222e+10],\n",
       "       [1.93000000e+03, 2.65468176e+02, 4.43481865e+00, 4.93095817e+07,\n",
       "        3.17251426e+10],\n",
       "       [1.93100000e+03, 2.73621855e+02, 4.76371503e+00, 5.03750538e+07,\n",
       "        3.30497819e+10],\n",
       "       [1.93200000e+03, 2.87081108e+02, 4.63717526e+00, 5.12068171e+07,\n",
       "        3.44502515e+10],\n",
       "       [1.93300000e+03, 3.04489092e+02, 5.56546667e+00, 5.20496356e+07,\n",
       "        3.66074639e+10],\n",
       "       [1.93400000e+03, 3.23560944e+02, 5.86832828e+00, 5.23637241e+07,\n",
       "        1.49492838e+11],\n",
       "       [1.93500000e+03, 3.36022543e+02, 5.78626131e+00, 5.32001843e+07,\n",
       "        4.13770794e+10],\n",
       "       [1.93600000e+03, 3.49520580e+02, 5.71237000e+00, 5.40420009e+07,\n",
       "        4.31039436e+10],\n",
       "       [1.93700000e+03, 3.68073025e+02, 6.08400000e+00, 5.51506305e+07,\n",
       "        5.14647052e+10],\n",
       "       [1.93800000e+03, 3.68667735e+02, 5.62409000e+00, 5.62586425e+07,\n",
       "        4.85952292e+10],\n",
       "       [1.93900000e+03, 3.71876675e+02, 5.13598500e+00, 5.73633329e+07,\n",
       "        5.07002760e+10],\n",
       "       [1.94000000e+03, 3.92819885e+02, 6.21570500e+00, 5.84622437e+07,\n",
       "        5.30509564e+10],\n",
       "       [1.94100000e+03, 4.03487775e+02, 5.31281000e+00, 5.95574505e+07,\n",
       "        5.56756612e+10],\n",
       "       [1.94200000e+03, 4.16846780e+02, 5.12409000e+00, 6.06566773e+07,\n",
       "        5.84952506e+10],\n",
       "       [1.94300000e+03, 4.28837690e+02, 5.16611500e+00, 6.17708000e+07,\n",
       "        6.08113882e+10],\n",
       "       [1.94400000e+03, 4.28381515e+02, 5.10072000e+00, 6.29108520e+07,\n",
       "        2.28589363e+11],\n",
       "       [1.94500000e+03, 4.15986975e+02, 4.65297015e+00, 6.37496104e+07,\n",
       "        7.02661572e+10],\n",
       "       [1.94600000e+03, 4.14815119e+02, 4.63991542e+00, 6.49249064e+07,\n",
       "        7.21757985e+10],\n",
       "       [1.94700000e+03, 4.18028522e+02, 4.05430846e+00, 6.61270025e+07,\n",
       "        7.42608540e+10],\n",
       "       [1.94800000e+03, 4.30632632e+02, 4.76718905e+00, 6.73626891e+07,\n",
       "        7.75410602e+10],\n",
       "       [1.94900000e+03, 4.47228348e+02, 5.02518905e+00, 6.86349248e+07,\n",
       "        8.02167197e+10],\n",
       "       [1.95000000e+03, 4.53406766e+02, 4.00651741e+00, 6.99476545e+07,\n",
       "        8.31968047e+10],\n",
       "       [1.95100000e+03, 4.62210936e+02, 3.94614851e+00, 7.09414788e+07,\n",
       "        8.61608996e+10],\n",
       "       [1.95200000e+03, 4.78523153e+02, 4.09196040e+00, 7.22951478e+07,\n",
       "        8.96054790e+10],\n",
       "       [1.95300000e+03, 4.83701158e+02, 4.33035149e+00, 7.36349355e+07,\n",
       "        9.18399976e+10],\n",
       "       [1.95400000e+03, 4.62401479e+02, 4.07867442e+00, 7.04417949e+07,\n",
       "        2.87759151e+11],\n",
       "       [1.95500000e+03, 4.63147069e+02, 3.91195370e+00, 7.12964321e+07,\n",
       "        8.89931221e+10],\n",
       "       [1.95600000e+03, 4.49755310e+02, 3.82867593e+00, 7.24455086e+07,\n",
       "        9.11286270e+10],\n",
       "       [1.95700000e+03, 4.51737218e+02, 3.98046296e+00, 7.35670679e+07,\n",
       "        9.50000355e+10],\n",
       "       [1.95800000e+03, 4.51002769e+02, 3.90697222e+00, 7.46730612e+07,\n",
       "        9.85532687e+10],\n",
       "       [1.95900000e+03, 4.59132736e+02, 3.89355556e+00, 7.57726141e+07,\n",
       "        1.03529008e+11],\n",
       "       [1.96000000e+03, 4.71418810e+02, 3.90297685e+00, 7.68673417e+07,\n",
       "        1.09378426e+11],\n",
       "       [1.96100000e+03, 4.72174935e+02, 3.94108333e+00, 7.79551479e+07,\n",
       "        1.14392720e+11],\n",
       "       [1.96200000e+03, 4.68864495e+02, 3.64160648e+00, 7.90374345e+07,\n",
       "        1.16057769e+11],\n",
       "       [1.96300000e+03, 4.74044898e+02, 3.69033796e+00, 8.01152240e+07,\n",
       "        1.20497518e+11],\n",
       "       [1.96400000e+03, 4.87528014e+02, 4.10560648e+00, 8.11924231e+07,\n",
       "        4.05364545e+11],\n",
       "       [1.96500000e+03, 4.91052876e+02, 4.13499078e+00, 8.18857550e+07,\n",
       "        1.32995781e+11],\n",
       "       [1.96600000e+03, 5.01657429e+02, 4.17121198e+00, 8.29529320e+07,\n",
       "        1.40058338e+11],\n",
       "       [1.96700000e+03, 5.27649986e+02, 4.28553917e+00, 8.40232687e+07,\n",
       "        1.48781313e+11],\n",
       "       [1.96800000e+03, 5.51165571e+02, 4.36819816e+00, 8.51008022e+07,\n",
       "        1.60684684e+11],\n",
       "       [1.96900000e+03, 5.69378346e+02, 4.40748387e+00, 8.61884600e+07,\n",
       "        1.72833481e+11],\n",
       "       [1.97000000e+03, 5.89150622e+02, 4.46541014e+00, 8.72874199e+07,\n",
       "        1.87258310e+11],\n",
       "       [1.97100000e+03, 6.05357235e+02, 4.56049309e+00, 8.83972334e+07,\n",
       "        2.02622297e+11],\n",
       "       [1.97200000e+03, 6.14363693e+02, 4.49316972e+00, 8.91063986e+07,\n",
       "        2.12341770e+11],\n",
       "       [1.97300000e+03, 6.05402261e+02, 4.30614679e+00, 9.02293067e+07,\n",
       "        2.18686592e+11],\n",
       "       [1.97400000e+03, 6.38698468e+02, 4.34052752e+00, 9.13588412e+07,\n",
       "        6.48597844e+11],\n",
       "       [1.97500000e+03, 6.60760638e+02, 4.41482569e+00, 9.24943692e+07,\n",
       "        2.50892455e+11],\n",
       "       [1.97600000e+03, 6.71722353e+02, 4.43537156e+00, 9.36351130e+07,\n",
       "        2.61456910e+11],\n",
       "       [1.97700000e+03, 6.75444963e+02, 4.34572477e+00, 9.47788442e+07,\n",
       "        2.72811457e+11],\n",
       "       [1.97800000e+03, 6.79250876e+02, 4.39187156e+00, 9.59228475e+07,\n",
       "        2.84144741e+11],\n",
       "       [1.97900000e+03, 6.79759064e+02, 4.35413303e+00, 9.70646551e+07,\n",
       "        2.93484682e+11],\n",
       "       [1.98000000e+03, 6.80078706e+02, 4.30106881e+00, 9.82030869e+07,\n",
       "        7.90672240e+11],\n",
       "       [1.98100000e+03, 6.89727908e+02, 4.30461468e+00, 9.93368299e+07,\n",
       "        8.14058917e+11],\n",
       "       [1.98200000e+03, 7.02617702e+02, 4.29612844e+00, 1.00460164e+08,\n",
       "        8.43178034e+11],\n",
       "       [1.98300000e+03, 7.07304212e+02, 4.40014747e+00, 1.02044038e+08,\n",
       "        0.00000000e+00],\n",
       "       [1.98400000e+03, 6.72990839e+02, 4.10428111e+00, 1.03151972e+08,\n",
       "        0.00000000e+00]])"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "f6b8e9bc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result = pd.DataFrame(total)\n",
    "type(result)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "id": "42ae6ca7",
   "metadata": {},
   "outputs": [],
   "source": [
    "#存储\n",
    "result.to_excel('D:/yanyi/data/other_last.xlsx',encoding=\"utf8\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "cdc909ac",
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "id": "4ccd9bfe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(25989, 7)"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filepath = 'D:\\\\yanyi\\\\data\\\\data.csv'\n",
    "df = pd.read_csv(filepath,encoding=\"utf-8\")\n",
    "data_raw = np.array(df)\n",
    "data_raw.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "id": "9fc52735",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<matplotlib.lines.Line2D at 0x239495f32e0>]"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYQAAAD4CAYAAADsKpHdAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAABHPElEQVR4nO2dd5wUVfLAv4+cQaILCwIKCiigrIComBUjBlREBT0UT9AznZ6c8Qw/IwYkKaKgp4igJ4hyiihiILgIIkEUBCSsgIBklmW3fn9U983M7qQNs7O71Pfz6U/3vH7d/Xpm99V7VfWqnIhgGIZhGOWS3QDDMAyjZGACwTAMwwBMIBiGYRgeJhAMwzAMwASCYRiG4VEh2Q0oKPXr15fmzZsnuxmGYRilivnz5/8hIg3CnSu1AqF58+akp6cnuxmGYRilCufcmkjnTGVkGIZhACYQDMMwDA8TCIZhGAZgAsEwDMPwMIFgGIZhACYQDMMwDA8TCIZhGAZgAsEwDKNUMGsWDB0KmZmJe0apXZhmGIZxsPDee9Crlx43bw4XXZSY59gMwTAMo4QzcSJUqaLHv/2WuOeYQDAMwyjBHDgAn3wCvXtDxYqwbl3inmUCwTAMowQzezb8+SdccAGkpppAMAzDOGh55x2oVAnOPFMFwtq1iXuWCQTDMIwSxo4d2vFv3Qpjx0KfPlC7dgmYITjnqjjn5jnnfnDOLXHO/csrf9g5t945t9Dbzgu6ZrBzboVzbrlz7pyg8k7OuR+9c0Odc84rr+ycm+CVz3XONU/AuxqGYZR4fv0VWraEZs2gaVPYswfuuEPPNW2qAkEkMc+Ox+00EzhdRHY55yoCXzvnpnnnnheRZ4MrO+faAr2BdkBj4DPnXGsRyQZGAgOAOcDHQA9gGtAf2CYiRzjnegNPAVcW/vUMwzBKD3v3qkupCDz3HCxZAo0bQ/v2ej41Ffbvhz/+gAZhU9wUjpgCQUQE2OV9rOht0eRTT+AdEckEVjnnVgCdnXOrgVoiMhvAOfcGcDEqEHoCD3vXTwKGOeec92zDMIyDgvvuUyHwySdw9tl5z6em6n7t2sQIhLhsCM658s65hcAmYLqIzPVO3eKcW+Sce805d4hX1gQINnus88qaeMe5y0OuEZEDwHagXph2DHDOpTvn0jdv3hxP0w3DMEoFP/0EL7wAAweGFwagKiNInB0hLoEgItki0hFIRUf7R6Pqn8OBjkAGMMSr7sLdIkp5tGtyt+MVEUkTkbQGiRCPhmEYSWLkSF1n8NBDkevk5Oh+x47EtCFfXkYi8icwE+ghIhs9QZEDjAY6e9XWAU2DLksFNnjlqWHKQ65xzlUAagNb89M2wzCM0sru3epNdPnl0LBh5HqvvgpVq8J550WuUxji8TJq4Jyr4x1XBc4EfnLOpQRVuwRY7B1PAXp7nkMtgFbAPBHJAHY657p63kV9gclB1/TzjnsBn5v9wDCMg4UvvtBR//XXR66zbRu89RZcfTXUrZuYdsTjZZQCjHPOlUcFyLsiMtU596ZzriOq2lkN3AQgIkucc+8CS4EDwCDPwwjgZmAsUBU1JvveSmOANz0D9FbUS8kwDOOgYOFC3XfuHLnO2LHqgjpoUOLa4UrrQDwtLU3S09OT3QzDMIxCc/nlsGABrFgR/nxODrRuDYceCl9/XbhnOefmi0hauHO2UtkwDCPJLFwIHTtGPv/JJ7ByJdxyS2LbYQLBMAwjiezcqTODDh0i1xk+XGcHl16a2LaYQDAMw0giP/6o+0gzhJUr4eOP4aabNMhdIjGBYBiGkUSWLNH9MceEPz9yJJQvDwMGJL4tJhAMwzCSyJo12uGnpuY9t2cPjBmjqqLGjRPfFhMIhmEYSWTNGmjSBCqEWQQwfrwmx0m0MdnHBIJhGEYSWbMGDjssb7kIDBumkU5POql42mICwTAMI4lEEgjffqvuqIMGgQsX7S0BmEAwDMNIEgcOwPr14QXCsGGaJe3qq4uvPfGErjAMwzCKmPnzYeZMyM7OKxAyMmDSJLj1VqhevfjaZALBMAwjCQwaBHO9zDK5BcLo0Tp7GDiweNtkKiPDMIxi5uefA8IAQgVCVhaMGgU9esARRxRvu2yGYBiGUcy8+SaUK6eeRCKBTGgA//mPqoxGjy7+dtkMwTAMo5j58EPo3h02bdLAddWqBc4NGwYtW+oMobgxgWAYhlGM7Nql8Yu6d4f69UPzJy9aBF99pbaD8uWLv20mEAzDMIqR9HTNb9C1a95zw4dDlSrRM6clEhMIhmEYxcicObrPnR1t2zb4978TmyIzFiYQDMMwipE5czT7Wb16oeXFkSIzFjEFgnOuinNunnPuB+fcEufcv7zyus656c65X7z9IUHXDHbOrXDOLXfOnRNU3sk596N3bqhzuiDbOVfZOTfBK5/rnGuegHc1DMNIKiIqEHKri3JyYMQIOPFEOPbY5LQN4pshZAKni0gHoCPQwznXFbgXmCEirYAZ3mecc22B3kA7oAcwwjnnm0dGAgOAVt7m29H7A9tE5AjgeeCpwr+aYRhGyWLNGti4Ma9A+PRTzZqWzNkBxCEQRNnlfazobQL0BMZ55eOAi73jnsA7IpIpIquAFUBn51wKUEtEZouIAG/kusa/1yTgDH/2YBiGUVaYPVv3uQXCsGHQqBFcdlnxtymYuGwIzrnyzrmFwCZguojMBRqJSAaAt2/oVW8CrA26fJ1X1sQ7zl0eco2IHAC2A7k0bOCcG+CcS3fOpW/evDmuFzQMwygpzJkDVauGZkf79dfiS5EZi7gEgohki0hHIBUd7R8dpXq4kb1EKY92Te52vCIiaSKS1qBBgxitNgzDKFnMmQPHHx+aDMdPkXnTTclrl0++vIxE5E9gJqr73+ipgfD2m7xq64CghdikAhu88tQw5SHXOOcqALWBrflpm2EYRklm3z5YsCBUXeSnyLzkkuJJkRmLeLyMGjjn6njHVYEzgZ+AKUA/r1o/YLJ3PAXo7XkOtUCNx/M8tdJO51xXzz7QN9c1/r16AZ97dgbDMIwywYIFGrguWCCMH6/rD4orRWYs4glulwKM8zyFygHvishU59xs4F3nXH/gN+ByABFZ4px7F1gKHAAGiUi2d6+bgbFAVWCatwGMAd50zq1AZwa9i+LlDMMwSgr+grQuXXTvp8g85hg4+eTktSuYmAJBRBYBeTxjRWQLcEaEax4HHg9Tng7ksT+IyD48gWIYhlEWmTMHmjULqIZmz9YUmS+/XHwpMmNhK5UNwzCKgdwL0pKRIjMWJhAMwzASzO+/w2+/BdRFGRkwcaIGsSvOFJmxMIFgGIaRYBYv1n3HjrpPVorMWJhAMAzDSDBLl+q+bdvQFJmtWiW3XbmxFJqGYRgJZtkyqFNHw1NMmqQqo1deSXar8mIzBMMwjASzbJnODpxTY3KLFnDuucluVV5MIBiGYSSYpUuhTRtNkTlrVvJSZMbCBIJhGEYC+eMP2LxZBYKfIvMvf0l2q8JjAsEwDCOBLFum+8aNk58iMxYmEAzDMBKILxDmzk1+isxYmEAwDMNIIMuWqZpo6lTo1i25KTJjYQLBMAwjgSxdqqGvV64sOVFNI2ECwTAMI4H4KqOSkCIzFiYQDMMwEsTOnbDWSyg8YEDyU2TGwgSCYRhGgvjpp8BxSUiRGQsTCIZhGAli9mzdt28PTZokty3xYALBMAwjQdx2m+6HDk1uO+LFBIJhGEYCyMgIHHfvnrx25IeYAsE519Q594Vzbplzbolz7jav/GHn3Hrn3EJvOy/omsHOuRXOueXOuXOCyjs55370zg11ThPHOecqO+cmeOVznXPNE/CuhmEYxcYVV+j+9ttLTorMWMQzQzgA3CUibYCuwCDnXFvv3PMi0tHbPgbwzvUG2gE9gBHOOT+M00hgANDK23p45f2BbSJyBPA88FThX80wDCM5jBkDX3+tx48+mty25IeYAkFEMkTke+94J7AMiGYe6Qm8IyKZIrIKWAF0ds6lALVEZLaICPAGcHHQNeO840nAGf7swTAMo7Rx3326v+UWqFEjuW3JD/myIXiqnGOBuV7RLc65Rc6515xzh3hlTYC1QZet88qaeMe5y0OuEZEDwHagXpjnD3DOpTvn0jdv3pyfphuGYRQLa9fCxo16/Le/Jbct+SVugeCcqwG8B9wuIjtQ9c/hQEcgAxjiVw1zuUQpj3ZNaIHIKyKSJiJpDRo0iLfphmEYxcaUKbpv2rTkpciMRVwCwTlXERUGb4nI+wAislFEskUkBxgNdPaqrwOaBl2eCmzwylPDlIdc45yrANQGthbkhQzDMJKFSCBe0fDhyW1LQYjHy8gBY4BlIvJcUHlKULVLgMXe8RSgt+c51AI1Hs8TkQxgp3Ouq3fPvsDkoGv6ece9gM89O4NhGEaJZ8MGVQ8NGBAoO++8yPVLKhXiqHMicC3wo3NuoVf2T+Aq51xHVLWzGrgJQESWOOfeBZaiHkqDRCTbu+5mYCxQFZjmbaAC503n3Ap0ZtC7MC9lGIZRXGzeDB07wtatkO31dE88UTJTZMbCldaBeFpamqSnpye7GYZhHOSMGQM33KBupv/4B3zzjabNrJfHLaZk4JybLyJp4c7ZSmXDMIxCMHWqGpDbtoUFCzRfckkVBrEwgWAYhlFA9u2D6dPhggtg3LiSnyIzFiYQDMMwCsgnn8Du3XD++TBiBJxwAhx3XLJbVXBMIBiGYcRJ795w662Bz8OGaVhrEfjll5KfIjMWJhAMwzDiYPFimDABXn8d9u6FhQvhs89g4EB4+WVNkdmrV7JbWThMIBiGYcTBSy/pfvdueOABOO00qFsXzjwTPvqodKTIjIUJBMMwjBisWKFG4379oFYtGDJEVUXp6TBpEpQrVzpSZMYinoVphmEYBy0i6jlUqZIuOKtWTT2LPv0U6tSBV1+FSy4pHSkyY2ECwTAMIwqvv66d/9ChkJKiqiPndFbw2muwbVvpNyb72EplwzCMCPzxB7RsCZ06wYwZKgR8RLQ8KwsWLSo9WdGirVS2GYJhGEYEpk+HnTvhqadChQHAnDm6MnnkyNIjDGJhRmXDMIwIzJypRuROnfKeGzZMz11zTbE3K2GYQDAMw4jAzJnQvXveyKW//w4TJ8L115euFJmxMIFgGIYRhg0b4Oef4dRT854bPVptBwMHFnuzEooJBMMwjDB8+qnuTzsttDwrS1cmn302tG5d/O1KJGZUNgzDCMN770GzZnDssaHlkyfD+vVqTC5r2AzBMAwjFzt26Azh0kvzehANGwbNm5fOFJmxMIFgGIaRi4kTYf9+uOyy0PIff4Qvv1TbQXGnyFy9Gi66SNuQKGIKBOdcU+fcF865Zc65Jc6527zyus656c65X7z9IUHXDHbOrXDOLXfOnRNU3sk596N3bqhzKnudc5WdcxO88rnOueYJeFfDMIyYbNgAd98NnTtDt26h50aMgCpVNCtacXP77fDhhxqCe+/exDwjnhnCAeAuEWkDdAUGOefaAvcCM0SkFTDD+4x3rjfQDugBjHDO+bJ0JDAAaOVtPbzy/sA2ETkCeB54qgjezTAMI988/rh2uG++GboY7c8/4Y034Kqrij9F5pdfqu0CYOlSDbudCGIKBBHJEJHvveOdwDKgCdATGOdVGwdc7B33BN4RkUwRWQWsADo751KAWiIyWzRexhu5rvHvNQk4w589GIZhFBc5OfD++5oSM7cHkZ8is7jjFn3zTcD1tW5dGD48cfaLfHkZeaqcY4G5QCMRyQAVGs65hl61JsCcoMvWeWVZ3nHucv+atd69DjjntgP1gD9yPX8AOsOgWbNm+Wm6YRhGTObM0UVnl1wSWp6Tox1xcabInDcPHnxQ03T6rF+vKqtEEbdR2TlXA3gPuF1EdkSrGqZMopRHuya0QOQVEUkTkbQGDRrEarJhGEZYMjPhrbfUmyiY//wHKlbUHMnBTJ+uKTIHDUp82xYuVONxly6ab6FLl0AbEikMIE6B4JyriAqDt0Tkfa94o6cGwttv8srXAU2DLk8FNnjlqWHKQ65xzlUAagNb8/syhmEY8TBypMYgOuIIWLZMy0RUIJx+OtSuHVp/+HBo2DCxKTIXL1avpmOPha+/VlvGqlXqzdSsWfgV00VNPF5GDhgDLBOR54JOTQH6ecf9gMlB5b09z6EWqPF4nqde2umc6+rds2+ua/x79QI+l9Ial9swjBLP2LHQti3s2wePPaZlixfDypV51UWrVsHUqZois3Llom/L8uVqqG7fXo3FDz2kz/znP1UwfPst3HMPVCiOZcQiEnUDTkLVN4uAhd52HqrjnwH84u3rBl1zH7ASWA6cG1SeBiz2zg0jkI+hCjARNUDPA1rGalenTp3EMAwjv3z/vQiIjBghcscdIuXLi6xZI/LwwyLOiWRkhNa/+26ts3Zt0bbjl19E+vYVKVdOpHp1kX/+U2TLFj23dKnIuedqO1NTRfbsKbrnAukSoV+1BDmGYRxU3HYbjBqlxuMdO9SbqEkT2LIFOnSAWbMCdffuhdRUVSNNnFg0z1+zBh59VGcplSqpXeKee8A3i65fD8ccoyqsu+6CG2+ERo2K5tlgCXIMwzAAXX381ltw8cVwyCG6TZ+uYay7dtWFZ8G88w5s3Vo0xuR169QuMGaMrm8YNAgGD4ZDDw3UycmB/v1VlbVwYfEHzzOBYBjGQcNHH+lM4LrrAmXdu8OKFXljFolo/uR27eCUUwr+zN9/hyee0AipOTlwww1qH0hNzVv34YfVzXTkyOREUjWBYBjGQcPo0ZCSAmedFVoebhlsYVNkbt4MTz+tHkr796sQuv9+DYwXjpUrVZV03XVw0035f15RYALBMIyDglWr4L//1U45Ho+dgqbI3LoVnn0Whg5VG8Q118ADD6iLazQ+/FD3DzyQvBzNJhAMwzgoGD1adfcDBsSuu3GjGpFvvjn+FJnbt8Pzz+u2cydceaW6kB51VHzXf/QRtGkDLVvGVz8RWPhrwzAOCj76SBd3hdPd5yY/KTJ37lRjcfPm8K9/wZlnwqJFMH58/MJg504NYHfBBfHVTxQmEAzDKPPs3KkLz046KXbdrCx1Sz37bDjyyMj19uyBZ57REf3998PJJ8P332umtaOPzl/7vvlGn9ujR+y6icRURoZhlHnmzVMPnxNOiF03VorMffvUY+iJJ1S1dM458Mgjmj+hoCxapPvc6TqLGxMIhmGUeWbP1r0fKC4aw4fDYYflDTGdmalrCB5/XJPonH66zgZOPLHw7Vu0CJo21XURycQEgmEYZZL9+9Wwe+ihuvq4bVuoUyf6NYsXw8yZ8NRTgRSZWVmaC+HRR+G331Tt9NZbRRtsbtEijWWUbEwgGIZRJpk7Fz74QDv26tU1t0Ashg/XENP9+8OBA9rxP/II/Pqrzi5efVWNxkXpFrp/v0ZcTbZBGUwgGIZRRvFjEm3YoHGCYnXi27dr2swrroBPP9VVwz//rAlxpk5VFVIi1gf89JMKn2OOKfp75xcTCIZhlEm+/FI72YYNY9cFeP112L1b8ya/8YZe+/77GvcokQvFfINySVAZmdupYRhljqwszSMQTwwiEfUsuuMO/XzUUTBhggaXu+SSxK8aXrRIo54mI3ZRbkwgGIZR5khP19F+9+6R64hoKIsuXXQWALoOYPFiVRuVK6becdEiNXhXrBi9Xk6O2kUOHEhcW0wgGIZR5pg2TTv0M87Ie04EZsxQb6Fzz9UgdAB16waM0MVJPB5Gu3frbKVrVw3Mt317YtpiAsEwjDLHxx/rIrS6dUPLv/oKTjtNPYV++01XJH/yiaqFbr45MSkyo7F5M2RkxBYIjzwCU6bo8cyZutAuEZhAMAyjTPH77zB/Ppx/fqBszhwNRdG9u+YwHjoUfvlFw0z7CWuSEXL6xx91n1sgbN+uC+FAV00//bQeOwcvvpg3fHdREVMgOOdec85tcs4tDip72Dm33jm30NvOCzo32Dm3wjm33Dl3TlB5J+fcj965oc6pqcY5V9k5N8Ern+uca17E72gYxkGEH0b6vPMCguGEE9RIPGSI5h249VZdb7B3r64tuPhiXSlc3Pzwg+6DBcK0aRoor0MHWLIkdAHcBx/A3/6WuPbEM0MYC4QLufS8iHT0to8BnHNtgd5AO++aEc45XyM3EhgAtPI2/579gW0icgTwPPBUAd/FMAyD8eN1//DDkJams4MnntDFZXfeCdWqBer6KTJvuSUpTWXyZA2g16iR2jaeeEIFWNOmmtnt6KM1mxuoofyiixLbnpgCQURmAVvjvF9P4B0RyRSRVcAKoLNzLgWoJSKzRUSAN4CLg64Z5x1PAs7wZw+GYRj54bPP4Isv9PiLLzQc9apVcO+9efMaiGgSnMKmyCwo69fr4rmrrtLPH36oqTWvvFKF2J13BuquXg2dOiW+TYWxIdzinFvkqZT8kExNgLVBddZ5ZU2849zlIdeIyAFgO1Av3AOdcwOcc+nOufTNvmuAYRgHPb/8opnJfN365ZerIHjwQc16Fo65czVc9aBByclQNmGCCqWrrlJ7wZ13qvvpuHE6U/jnP/V9/vxTg+0VBwUVCCOBw4GOQAYwxCsP97VKlPJo1+QtFHlFRNJEJK1Bgwb5arBhGGWPVavgL3/RTGP/+Y+WVagA774bO3KonyLz2msT385wfPCB2glat9aZzcqVqua6/np47DG44QZN6lO7dvG1qUACQUQ2iki2iOQAowE/Evg6INg0kwps8MpTw5SHXOOcqwDUJn4VlWEYByFr16pXUOvWajP429/URtCxY/i1B7nZuFGFxnXXxZ8is7Bs3qwL4f79b8178NVXAU+o77/X/f/9H7z9ts4QXnkl9mK1oqZAsYyccykikuF9vATwPZCmAG87554DGqPG43kiku2c2+mc6wrMBfoCLwVd0w+YDfQCPvfsDIZhGCFs2KCd5ujR+vmmm1S10rixRg1dskQT1sQiPykyi4IPPtDVz1lZoeXrPEX6u+/qftkyNXRfeWXxtCsPIhJ1A8ajaqEsdDTfH3gT+BFYhHboKUH17wNWAsuBc4PK01DBsRIYBjivvAowETVAzwNaxmqTiNCpUycxDOPgYONGkTvuEKlSRaRCBZEBA0TWrAmt88MPIiDy9tvR75WVJdKkichZZyWuvcF88YVIxYoiXbqIfPmlyOLFIldeqW2tW1fkq6/0GES+/jrx7QHSJUK/GnOGICJXhSkeE6X+48DjYcrTgTyZRkVkH3B5rHYYhnHwsWWL5i1+6SVNXdm3LzzwgOYxzo3v09+hQ/R7+ikyR4wo+vb67NkDmzbpIrleveCII1RdVKeOxiSaOVPrbd2quZhB1UdFkX2tMFj4a8MwShx//qmLyF54QeP49OmjHkPRIoIuWKCLzWJFDR02TL12glcyFzV9+qjgAUhJ0bATfra2BQvUhlGrFuzYEbjmo4/UHlK5ssYsatw4ce2LhAkEwzBKDDt2aGiGIUM0fMPll6vnTdu2sa/95hs4/nj1MoqEnyLzyScTF8Ru4UIVBldcAd26qRdUzZqB876gCBYGoHX69NHjatX0+quu0pAbxYUJBMMwks7u3Tpyf/ppVaP07KmLymKpf3x27tQwFffeG73eiBE6Au/fv/Btzs3WraoOuuMOHf2//HLeHM7bt2tuZoD771fPo5df1s/btsF330F2trbzww81Uc+LL2pk1o0bVTgkdM1EJONCSd/MqGwYpZ89e0SGDBFp0ECNquedJ5Kenv/7fPKJXv/pp5Hr/PmnSPXqItddV/D2huP330Xatw8YhsuXF3nttbz11qwROewwrZOaqmWrV+vnG2/MW3/XLpHTTw/cF0TGji18eymMUdkwDKOoycxU18//+z8N/3zmmRri+YQTCna/L79UFVC068eN05lIUccteuQRWLpU3yUrS9dB5DYOz58PF1ygRma/LQC7dum+W7e8961eXXM7z54Na9boTOK22zSJT6NGRfsO/yOSpCjpm80QDKP0kZkpMmqUjpBBpHt3dcUsLJ07i3TtGvl8drZI69bq+llU7N0r8tJL6gZ7882R602eLFKtms4OLrhApFIlkd279dzQofo9LF8e+3nff691x40rXLuJMkOwfAiGYSScAwc0if2RR8Jf/6rRPD/7TA280dJcxsP69ZowJlok0Bkz4Oefi252sGuXeindeqsGnXvoofD1hg7V0Nrt2mnspE2boHNnNRovWACDB6shvFWr2M885hj1ovLdaxOBCQTDMBJGdraGamjTRr1t6tfXbGbffKOqlaIwkPpeO35e5HAMGwYNGqjXUmEQgUmTtIP/8ktV/cyZk1eFk52t4TRuu03bNXOmqoDmzw9EVr3/fg2bMXlyfN9DhQoaDtsEgmEYpYqcHA3HcMwxGjyuWjUN3zBvnuYxLkpPmUmTdObRpk3486tXq8fOgAEFT5EporaCo49WoVKnjobX7ts3b10///FLL2kE04kT9f3nzVNBcdJJWmfGDHUrTUmJvx0dO6pAkAQF9zGBYBhGkSGiUUc7dtR4PM5ph7hggbqSFrXL5KxZ2jFfd13kOiNH6nMLkyLzySdVLdSggeZhnj8/sMI4mIwMVYF99BEMH67rKfz1Dt98o+3o2lWFQWamGprzQ4cO8McfGtMpIUQyLpT0zYzKhlFyyMkRmTpV5Ljj1PDZurXGFDpwILHP7NxZ4xL5Rtrc7NkjUq+eyKWX5j23c2d8z/ngAxHnRPr00WdGYtEikaZN1bV16tS853v0EDn6aD2+4QaRWrXUyJ4fvvxSv9+PPsrfdcFgRmXDMBKBCEyfru6eF1ygISfGjtWoo1ddlbjVwKBG2nnz4L77QtNiBjNhgsZDym1MfuMNVftMmBD9GatWaeKdtDTNvRxphvPpp6oKys4ODWvtk5Oj7qMnnqgxmd57T+tUqhTXqwIaGfWuu/Q494K3IiOSpCjpm80QDCO5fPGFyMkn64i1aVORV14R2b+/+J5//fU6Gt+xI/z5nBydsbRtGzqy37xZZw3OafTUxYsjP+OKK9Rl9LffItcZPVoXo7VvL7J2bfg6ixYFXEbffluPp0+P/Y4+X38t0qiRSI0aOmMpDESZISS9Yy/oZgLBMJLDN98EVtA2biwyfLjIvn3F24bt27WjvuGGyHVmz9Y2Dh8eKFu7VqRDBw1H/fnnInXqiFx4YfjrJ0/W6x9+OPz57GyRe+/VOj16aJsiMWqU1luxQuTMM0WaN9fr42HUKG1vq1YiS5bEd000TCAYhlFo5s3Tjg9EGjYUef551dEng5EjtR1z50auc/XVIjVrBmYQCxeKpKRo2X//q2X/9396n2+/1c979oiMGaMzg0qVRNLSNIREbvbuDeQ0uOkmzbEQjWuv1RH+tm06mxg8OPY7ZmZq3gdf4GzbFvuaeDCBYBhGgVmwQEfRoKqWp58O30kWJ8ceqyP9SEbe338XKVdO2/zdd1p2wgkqEH78MVBv1y4Vbqedpp/PP1+vadZMhcKWLXnvvWmTSLduWu/pp6Mbmn1athS55BKR997T62bNil4/I0PkxBO17r33Fq1x3gSCYRj5ZvFikcsu016iTh2Rxx6LrK8vTtLTtU3DhkWu89hj8r+AcPXqicyYocePP5637osv6rm77tL9o49G7uSXLxc5/HC1PUycGF97MzL0vs8+qyP+mjWj21rmzVPPqWrVRCZMyHt+6dL41U3hMIFgGEbc/PSTyFVXqdG1Zk2RBx8sOnVFUXDTTSJVq0Zuk58iE0QOPVQjqVaqpJ+XLctbf98+kaOOkv8Zx/fuDX/fWbM05WWDBmqfiBd/VvDttxrP6OKLI9cdN06kcmWtt3Bh6LmcHP09Eul2GrPjBV4DNgGLg8rqAtOBX7z9IUHnBqP5kZcD5wSVd0LzMK8AhhLIqVwZmOCVzwWax2qTmEAwjCJnxQqRvn1V1VK9uuq5w6lMksnOnepp069f5DqTJgVmBw89FAiN3bZt5Gv27tXrcnfCPv/+twqVI48UWbkyf22+6y7t5P2czyNH5q2TlSVy++16/rTT1BMq9/ngMNiRhFY8FFYgdAeOyyUQngbu9Y7vBZ7yjtsCP3idfAtgJVDeOzcPOAFwwDTgXK98IDDKO+4NTIjVJjGBYBhFxurVIv37q7GzShXtwDZuTHarwvPqqxIzGf1pp8n/8hKsX69lb7yRPzdPn5wcVSGByCmnFExAdu2q9oAXXtD7/Ppr6Pk//gh4bd12W3h1UsuWAWGQ38VsuSm0yghonksgLAdSvOMUYLkEZgeDg+p94gmBFOCnoPKrgJeD63jHFYA//NlDtM0EgmEUjnXrNGxzxYo6+r31VpENG5Ldquh06SLSpk1kHf/ixYGO86abCveszExNpgPqJVSQjnjPHv1+77lH5Nxz1XU0mB9+UBfUypVFXn9d32viRJ0tvPWWfn788cA7FYV7byIEwp+5zm/z9sOAa4LKxwC9gDTgs6Dyk4Gp3vFiIDXo3EqgfoR2DADSgfRmzZoV/psxjIOQjAwdiVaurJ3VX/8aeUFVScJXuTz/fOQ6F10U6Dzzq9oJZtu2wKj94Yfj8yQKx1df6T0mTFC7x623Bs69+64ajhs3VvfZAwcCbqYVK4aqiEDfvyiIJhCKOnRFuIXdEqU82jV5C0VeEZE0EUlr0KBBAZtoGAcnmzfD3XdDy5YaDvqaazRHwMiRkJqa7NbF5l//0nwA114b/vz27TBlih5/842+Z0FYvVozmH31lYa4eOihggfl++ADDVtdoQLs3auZ4bKzNdzGFVdosLr0dM2R8I9/wCuvaF7oPXs0FIbPv/8N7dsXrA35oaApNDc651JEJMM5l4IanQHWAU2D6qUCG7zy1DDlwdesc85VAGoDWwvYLsMwcrF1q0bdfPFF7ZSuvhoefBCOOCLZLYuPVatUaL3/PjzxBNSrF76en5by0EPDp6SMh3nz4MILYf9+jU906qkFuw9ozKKxYzXK69KlKlTat9fPH30EN96oIbIrV9bnDhkCgwbpO777Lnz7rYb0fvNNTcJTLESaOohEVRk9Q6hR+WnvuB2hRuVfCRiVvwO6EjAqn+eVDyLUqPxuPG0yG4JhROfPP9XLplYtdSG98srwbpclmZwctRn43jeR/PezswOqldGjC/as999XtU6LFkXzPb30kvwvZtFZZ6kaqHVrTbk5YkSoGuqJJ7Tu5s3qplq+vMaJijcia36gkF5G44EMIAsdzfcH6gEzULfTGUDdoPr3oXaA5XieRF55GmovWInaGny30yrARNTtdB7QMlabxASCYURk5041RB5yiP6HX3qpBlcrjcyape8wZkz0ep9+GhAIv/+ev2fk5IgMGaJCs2vXovGw8oXBKaeoMdpvW8OG4VcpX3CBurROnqwCo1u3xC0CLJRAKKmbCQTDCGX3bpFnnhGpX1//sy+4QBOzl2auvVZnOLFCZfihNbp2zd/9s7JEBg7Ua3v1KprYTFu26AKys8/W9QLBhu5wUVOzs3XB26GH6iyic+fogfIKiwkEwyjD7N2rPu6NGul/9DnniMyZk+xWFZ5169QdduDA6PVWrQp0uOPGxX//nTtFzjtPr7vnnsKFg1izRuTvfxeZP18X9Dmnq5kvvTTQtkheT0uXBup06pT4VeEmEAyjDJKZqbpoP0zDaaepm2NZ4c47VZeeeyFXbv7xj0CHGm/QvXXrRDp21PuPGlW4di5apO6joLOz8uV1IdrRRwcC7B1+eOTrr7hC61StWjwrw6MJBMuYZhiljKwszd7VqhUMHAjNm8Pnn+sW7KpYmvn+e/Us6tMHWrSIXG/vXnjqKT2+9VaoXj32vX/4Abp0gRUrYOrUwuVazs6G/v31uR9+CLt3a9m8ebB+PUybBnXrap7lcMycqR5FAL/9pnWTiQkEwyglHDigfvFt2qjL4qGHwiefqL/8aaclu3VFx/r16vrZoAE8/XT0usEpMO+5J/a9p00LCM2vv4YePQreToChQ+G773R//vlw3XVafuSRur6gSRN1+w0nEL7+Gs4+W48vvRTq1y9cW4qESFOHkr6Zysg4WMjO1rSLRx6pqoVjjxX58MOCr54tyezere9Xs2Zsz6icnICq6JZbYt971ChV5xx7rKqM4iEnR3X6K1eqCuieewLnfv1VVUXnn6/G6Guu0bZcdlnAXfSBByRs/KJvv9UgfX77J0+Orz1FAWZDMIzSR3a2RuBs107/U48+Wn3Uy6Ig8PHdNadMiV33ww/jsx1kZ4vcfbfWO/987ay3bFGPrGefzevRM2OGhq1o21bzQPjPcE7306bpb3DmmSq4vvlGczc7p3kY/N9n3Tq1C1xxRej9585Vz6lWrfQeVaokZr1BJEwgGEYpIidHR4wdO+p/6FFHibzzTuG8YEoD2dnaSXbpEl9dv6OOFvl0z55Akp9Bg9TNdNWqwGwLND+B34lv3qyG4dRU9RAaOFDkqadE/vlP9SA68kjt/MeO1Wt79w7cp3btQFu++07kiCM0XlTw7CA9XYVMy5YiH3+sQuTuu+P/jooi+KAJBMMoBeTk6Ojz+OPlf54pb7xRtOkTSzLTpul7jx8fu+5f/hIYtUdi40YVLs6JPPecfr+//qod9SGH6AKxZ5/V+6SlqWBo1kzXAgSn2VyzRtVNl18e6PzDbfXr66Kyvn11ZtCsWegitJkzA3UfeUSFRe3asT2LsrNFPv88sJ5hxIjY3080TCAYRglnxoxAnt7DDtO4/9HSLJZFrrtOO8hYYaY//jjQsS5dGr7OsmUagqJqVQ1JIaJ2Bt+989tvtcxfpXziiSLHHKML3D74IHCfr77STt7PphZJGCxYoLaGq6/Wd+jWTQWJiOZk6N49/HVNmkR/1507A3me/a1yZU3lWVBMIBhGCWXWLJFTTw10DiNHFj4BSmlk/35drXvttdHr7d2rAhO0kw3HF1+oWqZhQ9XXi+ge1PC7YkV8bdq9W1VYzZur4MnJCdgigrfcsZMyM0XOOEOzzvkhtP3tpZd0EaGvDgSNORVMTo4asU85JbIQKUwobBMIhlHCmDNHA56BhiwYOrRwaRFLO36aS380Hwk/exmEjuR9xo1TlU/btiI//6xeQeeco+qchg3jDwmxZ4+GnnAukGktOF4SaB6DsWMD9oecHBU8556r5889Vw3Gfn1/VL9/v0hKirYHAkKjaVNta24BUK6cZrF7910NfVFYpwITCIZRQpg/P6ACqF9fddi7dye7Vcnl3XfV66ZevejfxerVqu4B1c8H21ZycjSyq9/Bbtsmcu+9+vm449T4G+8q7mBh8NprWvb664EO+tVXNRubc/p7iqgTgB+VtWZNTeLzyy8qNBo2DERP3b9fQ1uAvm80m0SwO+q+fdr+onAsMIFgGEnmhx/UaAlq0HziieJ1NSyJrFun4SlA5IQToqtysrMDMyrQ789n3z5VNYHaITIz1T3XOZEbb8x/uwYNCgiD/ftF/va3wHOvv17rbNsm0qCBCpvmzeV/I/nRowPrFlJTtfzBB9W4Ha3jf+ON0M9/+5vOckDdVk84QY+7dRPZujX/7xSMCQTDSBJLlwZi1dSqJfKvfyU2kmVpYccOVZs4p51stFzB2dmBBV7ly6tRddMmPbd1a0DX7q8BmD5dg+KdcEL8sY18Vq8OpBXdvFnjQ/md9NVXB2YlOTkBAe9vFStqsLy0tOidf/CWmqrP6dpV3+2VV9Q1VkRViIMH6wCialVVG4GqFwuDCQTDKGZ+/lkNmOXK6YrU++4r/MiuLOF38PGocfr107oXXaSG2n79tHzlSl0XUKmSruQWUT//6tXVYyi/3/f+/drJV6yoC+N84zVoSGo/dPXcubFH/Lm3k05SA7X/uVWrgA3B3/r0Cd/mAwdUOPj5matXz9975cYEgmEUE7/+qiPe8uV1VHfPPToCNALs2qUhH3r3Dn/eXzyWna1GZlB7wIsv6vG8eRpaukED9Uzyff137NAFX02bxreAK9g4u359wKDbubP+dqmpag+I1dnXrasG5BtvDC8IatfWY1+1BHmFQbAB+e9/z+ty/NNPgYRHIJKRUZBvXjGBYBgJ5rffRAYMUJ/1ypVFbr89/5m7Dhb8dQSffpr33Ny5gY7v6KPVS6djR7ULHHmkdtYTJ2r5EUeE+uP37asdaqxZx88/q62hZk01EK9YoR10pUraufud7hlnRBYC110n8u9/q+E4J0dtRMHnq1XT9hx3nA4Q3n9fZzSgq579pDz+dt99uhalf3/9nJamgu6ddwKqouCtf/+Cf/8mEAwjQWzYoAueKlVSVcPAgfEHTjtYuf127dBzZyfbuVM7+WbNNFxEs2aaxWz9erULgKqCfONq8Mzrrbe0/KGHIj931y7tnPOj6vG3F15QV+Fwto5hw/IKiwUL8tYbOjS0XvCIPz9blSqF+xtLmEAAVgM/Agv9hwB1gelovuXpwCFB9QejuZOXA+cElXfy7rMCGIqXbznaZgLBSCYbN6qHTJUqOiu48cbAylQjPN9+q4H6GjRQt87c3H+/9kgzZ+Y9F7xa98orQ9dsfPedqnhOPDFgkBVRA3HnznrfPXtCDcTxbpdfHv5d9uxRA/ARRwTqDh+u+v61azXg3fjxKtgGDdL3LUjnH277/PPC/Q6JFgj1c5U9DdzrHd8LPOUdtwV+ACoDLYCVQHnv3DzgBMAB04BzYz3bBIKRDP74QzN0Vaum6ol+/SKnRjzY+eEH7RxF1CuocWO1rYDGFvLJzNQRdY0aeSODimgYbL8zHDw44IuflaUzgqpVVT+/cWPgmm3b1J4QrWOtUUPbFFxWvnwg+9lddwXaPmqUxhCaNk3khhvC3++wwwLvl/s5wZ8feECN4F9/rYOIrVvV9hScbjPaVqlS4X6X4hYIy4EU7zgFWO4dDwYGB9X7xBMCKcBPQeVXAS/HerYJBKM42bZN/5Fr1lRXyT591NBnBFi3Tl0/H3xQcw6AyMkn67m779bOMj1d5D//UdXLk09q59qsmdYtVy5vbKLffgt0hA8+GCjfsEFDR4Map1ev1sVfY8eK9OwZu1MNjnZ6/PG6AOyuuwIqqSZNtH3BnkHRtu7d1avsn/9U4fHxxyKLF2tYiuuuC9SbNy/wDjt26FoH323WObVbPPdcYObRq5fapi68UOTNNwP3+fnngv9OiRQIq4DvgfnAAK/sz1x1tnn7YcA1QeVjgF5AGvBZUPnJwNQIzxsApAPpzZo1K/g3Yhhxsn27Rqb0PUV69dJ/dCMUX23jd1gdOmiMpgoVdFZ1yCH63fn43kM1a6paZ8wYkYULQ+/5/fcBI2+NGqHP8p/TpIkuWAvOW+BvDRqocfajj9Tw26lT5A49WuA60EB5PXvqegF/ERxoToZw5ORoO32h5bc1K0tkwoRARNvgmcl558UnfEDzZBSURAqExt6+oacO6h5FIAwPIxAuA44PIxA+jPVsmyEYiWTXLh0h+h1Sz57hDYWGctZZ2gH/+qvq93NyAt5Efs6AmTO1fPdukUaNdBYRKaLr1Knqb+93gI8/robdzp1DO8Zy5VT4/OUvIjffHCjv1Sv+zjXa1rFjqIvn9u0qFPy1CiKq8lq3TgXYtGkaTym/z/GT78S7xYr5FI1oAqEChUBENnj7Tc65/wCdgY3OuRQRyXDOpQCbvOrrgKZBl6cCG7zy1DDlhlHs7N0Lo0bBk0/Cpk1w7rnwyCOQlpbslpU8nn0WfvoJLr8cpk/Xzy1awO+/w1tvwZYtWu+dd/T7+/13zTF81lmwcaMml69YMfSeInDnnfDCC6Hl992X9/lNmmje5S1b4LXXQs9NmhS7/c2bw+rVecs7doTFizWHdbVqcMMN8NlnkJkZWu/uu6FfP9i2LfazctO+PTin99y7F9asCV8vJQUOOwyaNdPtsMOgZUs455z8PzMuIkmKWBtQHagZdPwt0AN4hlCj8tPecTtCjcq/EjAqfwd0JWBUPi/W822GYBQl+/ZpaOKUFB2BnXlmIGb+wcjrr+uoPBL//W9gtFq+vEjr1jryHz8+YJQN3h56SOv5I+FOnXS2sGWLql2uvz78dZG2ihXVaHzqqXnzBRTnltsond+tXLnQtQ8jR6oX0cqV0cN5FAYSoTICWnod/A/AEuA+r7weMAN1O50B1A265j7Uu2g5QZ5EqB1hsXduGOZ2ahQT+/eLvPxyQIfcvXt4t8eDheXL1QOmXDn9PqZNy1tn9279vtq105g/jRvrdX//u15z0kn6+b779PNllwUie8by/Am3XXhh4PiKK9SgnJ2t6xamTElMR9+unS4q89NvBm+x7A2RtvbtNb7S5ZerEAsWgM2aFU16zHhIiEBI9mYCwSgMWVnq4dGihf4XdO2qi5/KcgL7WKxalXeU3rJl3oQ9jz2m52bNUoG6YkVoHP/rrxfp0SP+jjLYl/+yyzQsxdtvh6/bubO6dwYbsOPZKlfOW3bSSSrMatfWsBgzZxZM/x+8OafrJCZNUs+nzz/X8gkT1C7l/31lZ4vcdlvotc8+mzdZTiKIJhCcni99pKWlSXp6erKbYZQysrNVp/2vf8Evv0CnTvDoo9Cjh+p0DyYyMuC552DdOvj1V9i1C5YuhSOPhOXLA/UGDlSd9W+/qT1l8+aCP7N9e+jaFapUURvNzJlqW4iHjh2hUSOoVw/efjtyvYEDYcSI0LKqVVVX71OvXsDGUVScfz506QJt2qgtZfFiuO660DoVKqhtIjcnnACzZ0P58tCzJzz+OBx1VNG2z8c5N19EwlvFIkmKkr7ZDMHID9nZOkrzk5i0b68Zt8rajOC99zTGjs+MGern3revesI8+2zgvJ+0PRlbrVqhn9PSdJ3H88+re6ZfXrOmxvPx2b49sM6gceOAasvfIuUuzs9Wt666wRbl+w4cqF5rwS6roDOyefPUQ+nLL3UtRJ06+v1cdpkGzbv4Yp11TJlSNH+vmMrIOFjJydGFUO3b6197mzaaoasoMk+VNL74ItDRfPedGsmLu6Nv1kwN8ldfLXLHHeqOmpambqTz5unK3D17VF1XoYIGsPNDfmRlqX7dv9cjj6i9YvlyDYQXLr1kQbbKlTXj2YIFqvKaPVtkyRI14u7fH3+YieefDyT4qV07/CK2a68N5FCYMEE7++rVVcitXRsaz6hNG71nerou6Dv8cDW+H320uumCCof85njIjQkE46AjJ0cXJPmLkVq10gBowWkXSzOZmeqJ8sUXqtMPtzAr0dvzz+sivc2b4xewOTmBmEVnnaX2h/T0wEK1gmydOgXSZ/rbqFGh+YxBc1c/80wg58Aff2iGs48/VgF1882hORBybytWBCKg+gsVK1XSVc/r1unf1rBhGtfqiSc0KJ+IPq9PH63fpYtGSPX55BM1lA8dGvhbrVBBZxRvvKHf1c036+eePdVG4YfUKCgmEIyDhpwcHU127ap/3S1aqAtlcNCzkk5OjnZW33+vs5sXXxS59Vb1UKlYsWg79XLlQuP0B2+5R7y+EbRdO52BxCJYaI0dG/A6KoqtX7/Ab/rJJ6Hn/AVx/tatm4aD2LNHw0U8/7wGwovXzXXw4MA7ffZZoGP3zweH4A5m0yaRIUNUtVWhgmbLi7QQz2fxYu38fffccuXUQyv3716YsCnRBIIZlY0yw5dfwgMPwFdfQdOmcP/9cP31eRc/JZvMTFi7Vo2O330H6em6L8gCp9x06QJ//AErV+rnUaOgWzfYuRNOPDHydXXrQufOavDt0kWP69ZVA2iHDrqAa88euOQSmDBBjaN//qmG5jVrdJ/7OCNDu6+iZsECXaC1cCGcfnrouYceUocB0Pd9+21d0LVjhy6cGzoUtm/XhXL16qkR9+OP8z7DObjwQrj4YujbV+uBvk+5cqF1W7fW7+uuu9TwvX49PPMMvPKKGrK7doXHHtOFdOvXw/jxalDPzoZ27dSpYd48/Y43bYLjjtPv7ttvYf9+fd/cXd38+VqvIJhR2SjTfPNNYCqfkqLT9kQt6onG/v2B2P1PPKHRKwvqs+5vhx+uBsVHHlE1SDh3zr59dRQe/M67dqmR8umn1TjpJ3wP3m65RQOm/fxzXmNlVpbq9mfNCiRtAbUPtGuXN4InqG6+VSv9LYIDzOU29PprEqJtvXqpYTVYx/7Xv+raAz/9Zu7ND0wHqgoSUXXNCy9oWA1QNVWsqKLXXqvqoWB27dLAdf7CRVC10XPP6ZqCaCo735EheIsnE1u0LZ4ZWiSwGYJRFvnuO3jwQfjvf6FhQ7j3XvjrX9XFsCgQUVfMjRt15LZpk45858/XEdvSpQW/d8OGcPzxOlLt1ElHsQ0bQv364cM5rF6tI9YlS7Ts1lshKwuuuUZdFn/6CebMgblzdVu8WEegoKEOunQJbB076rXRRvfr1weu96lfPzSEQu7jBg30mief1N8lXo4+GrZuhQ1RAtb8979w+OFw9dU6mo7GoEHahmee0VnBnj2R6551lobd8Fm2TGcA48ere+3w4eGvq1VLZx3JYsgQDfFREKLNEAoVy8gwksHChaoamDJFp/1PPaWdQPXqsa89cED9z4M7ef9440btcNPTISenYG2rVk07+eOPD3T4LVsWfI3D4sVwzDGhZZdcAmeeqR3/Qw+pYPQ7p9q19Zn9+mkcnEMPDcTKmTEDXn9dj//8M/SeFSqomq1ZMzj1VEhNVRXHEUdoWdOmkb/fnBxd2/Hkk/Djj5Hf5cEHYdgw7fwBRo/WOEGg6r5TT9XjPn2gd2/tyN96Cz78UNeJhKNaNT13yim6RmLLFv0Na9aM3A6AOnVU5RIsDEDXEMRDJGFQrZp+V3v3qmBNFE2aJOa+NkMwSg1LlmgH+N57+g99111w2206ogvu2CMd//ab6tILynHHaSffqVOgo0xNhcqVi+wVAe2sx4/X0ak/I4iHQw/VBV/r1+sMIJg6dQId+2GH6bZokXa4M2aoYP3731WgHHus2l9AR+0pKXmflZWlwd3ef1+/09wCxqdbN/2dtm3TTtQf1V54IbRqpTr+3AvT/vEPFcozZsT/7gcby5er7aIgRJshmEAwShw5OTrS8zvzr76Chx8OrXPUUWqc3bQJdu8u3PNat9YVtOHUIHXrFt8K5pwcNWC+9Vb+ritXTkeMhx2m30njxjpqbtZMV/ZOmgRPPw1jxuj+8MNh8uSAoTQW06Zp23bv1k590iRV4cRLxYp5BVRhueEGFV5DhsSue8UVGlm1tFO7thrEQYV57pljvJhAMJLO3r3RR+/Bx5s3F1xlE0y1aqGdfO6tSZOiH93Hwvcw8m0REyeqyicW9eqpJ4svrFJTtYOoVEltDAsXwptvqg4c4IILVNA991xCXycuDjssEN65TZtAG1NSVLhs26btjYfzz1eh9NVXiWlrYWnRAmrUUPVa8JaTo+rKzEztzPfsCWy56dBB71O+vAr7Awd0pjZ3rp7v3RvGjdPfviCYQDCKnJwcVRME69+jdfKRVDU1aqixMjg2fDzul85ph5K7kw8WAIccUrzxiURUPx5spF2zRjvABQvij9kD2ok0bKgzlIoVdXS+a5fe3x8lllTOPFON148/nuyWFC0VK0L37mqvOPlk/W0fekhjQWVnq1ru+ONVYO3fr3/LGRnaqReFS3EwU6eqcCwIJhCMuPBVMPGM5DdvDh+kyzn1NmnYULdGjbTTz8zUbd++wH7fPvWZX7s2b/IRnw4dtHMJN7ov6AgpHCLanl27dPM74ODjbdtUd7t0qW756eDjJXcQtmRQrVp0z5zSQrt22iH7RuxgqlfXAcO6dXnP1amjdqLgrWVLVXv5g5sDB/Rvd+FCFQDffguffproNwrw9dfR15VEw7yMDlJEdDQZa/TuH0caeVatqh17w4aqqujUKdDhN2igdfyOftcuNWr6o+RFi/QfJxjnVM/drJneq1s3NS76AuaKK9RdsGlT8iCio6+dOyN33PF8DneuKNRU+aFLF/WMqVxZPaaGDUu+MICSLwxat9bfa/36vOeqVg0I92gG+d27Q21P9evriLttW/VQ2rNHBxzbt6taa/ZstbuUdWyGUMrIytLReaxO3t9HMubVqxfo5P2RfLjjGjV0hOXrvXNva9dqBx1MjRqquklJUZVHvXq697c6dVR4rFqlU+7g608/Xf85o3Xc4WYmkahcWUeDVauqECmI73idOjrabNtWvYuyslSnmzvEclmiTx813D/zjH5vNWro92+UHAradZvKqAQjov9w8ejhN20KP/0FHc00ahS7k2/USDvcChV0RLxxo8bCX7YsoApZulQ7+oJQs6bee/fuvIIiFnXqaMfjb9WrR/6c+xyoZ9LWrbpt2aKCc8UKfbd4Rt5Vq6rwqldP1UEbN+b79YudSpXU26RjRzXMNm6sv91HH6nrZqNGqgL6+msVwrt3q5CsXVv/nkBH3EceqXaONm3UmLlxo6pbilotdvnlqqaZPbto73uwMXu2hsQoCCYQihlfvxhvJ79vX/j7HHJIaGdev36gM6xWLXRfrlxgNO3vN24MdPRFmQykVq2CddzZ2fDqq5oUBXSF7aOP6sg7Kyswjd+9W6fs/vGuXQGhtWxZ+MTohnGwUaZnCM65HsCLQHngVRF5Mlr94hYIu3bF7zaZW2ceD9WqhXby1arpCDtYVZII3W7Nmtoht2mj+yZNQjvyypVV5+9v2dnhO+1Infnu3fq9hAs3UK5c8evtDaOskAiBUCKMys658sBw4CxgHfCdc26KiBQiWkx0srN11LxmjeqyV67UUai/Feco1PdVrlYt0Bn7C4EK6mZYu7bOMGrVCnTuVauqDn3rVlWnbN2q6io//k1xY8LAMEoWJUIgAJ2BFSLyK4Bz7h2gJ1DkAqEk5s3N7fFQFGzfXvL91Q3DKFmUi12lWGgCBJsx13llITjnBjjn0p1z6ZsLmOk7d/x0wzAMQykpM4Rw4/Y8GjIReQV4BdSGUJAHWcAswzCM8JSUGcI6IHgZUioQJTq6YRiGUdSUFIHwHdDKOdfCOVcJ6A1MSXKbDMMwDipKhMpIRA44524BPkHdTl8TkXxEgjcMwzAKS4kQCAAi8jEQJt21YRiGURyUFJWRYRiGkWRMIBiGYRiACQTDMAzDwwSCYRiGAZSg4Hb5xTm3GVhTwMvrAwUIQVeqKOvvaO9X+inr71hS3+8wEWkQ7kSpFQiFwTmXHinaX1mhrL+jvV/pp6y/Y2l8P1MZGYZhGIAJBMMwDMPjYBUIryS7AcVAWX9He7/ST1l/x1L3fgelDcEwDMPIy8E6QzAMwzByYQLBMAzDAMqQQHDOveac2+ScWxxUNsE5t9DbVjvnFnrlzZ1ze4POjQq6ppNz7kfn3Arn3FDnSkbSzQjv19E5N8d7h3TnXOegc4O9d1junDsnqLzUv19p/P0g4jt2cM7N9tr8oXOuVtC5svAbhn2/0vgbOueaOue+cM4tc84tcc7d5pXXdc5Nd8794u0PCbqmVP2GiEiZ2IDuwHHA4gjnhwAPesfNo9SbB5yAZnGbBpyb7HeL9H7Ap377gPOAmd5xW+AHoDLQAlgJlC9D71fqfr8o7/gdcIp3/Bfg0TL2G0Z6v1L3GwIpwHHecU3gZ+93ehq41yu/F3iqtP6GZWaGICKzgK3hznnS9wpgfLR7OOdSgFoiMlv0V3sDuLiIm1ogIryfAP6IsjaBLHM9gXdEJFNEVgErgM5l6P3CUpLfDyK+45HALO94OnCZd1xWfsNI7xeWEv5+GSLyvXe8E1iG5n7vCYzzqo0j0N5S9xuWGYEQg5OBjSLyS1BZC+fcAufcl865k72yJmg6T591XllJ5XbgGefcWuBZYLBX3gRYG1TPf4+y8n5QNn4/gMXARd7x5QRSyZaV3zDS+0Ep/g2dc82BY4G5QCMRyQAVGkBDr1qp+w0PFoFwFaGzgwygmYgcC9wJvO3pNsPp8UqyX+7NwB0i0hS4AxjjlUd6j7LyfmXl9wNVowxyzs1H1RD7vfKy8htGer9S+xs652oA7wG3i8iOaFXDlJXo37DEZExLFM65CsClQCe/TEQygUzveL5zbiXQGpXUqUGXpxJDTZFk+gG3eccTgVe943WEjsT89ygT71eGfj9E5CfgbADnXGvgfO9UmfgNI71faf0NnXMVUWHwloi87xVvdM6liEiGpw7a5JWXut/wYJghnAn8JCL/m6I55xo458p7xy2BVsCv3nRvp3Ouq2d36AtMTkaj42QDcIp3fDrgq8SmAL2dc5Wdcy3Q95tXVt6vDP1+OOcaevtywP2A721TJn7DSO9XGn9Drz1jgGUi8lzQqSno4AVvPzmovHT9hsm2ahfVhqqEMoAsVAL398rHAn/NVfcyYAnqAfA9cGHQuTRU77kSGIa3mjvZW7j3A04C5nvvMRfoFFT/Pu8dlhPkwVAW3q80/n5R3vE21FvlZ+DJ4PaWkd8w7PuVxt/Q+3sUYBGw0NvOA+oBM9ABywygbmn9DS10hWEYhgEcHCojwzAMIw5MIBiGYRiACQTDMAzDwwSCYRiGAZhAMAzDMDxMIBiGYRiACQTDMAzD4/8B8s66A5eEefMAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.plot(data_raw[:,2],data_raw[:,3],\"b\",label = \"total\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "id": "ae96a0e7",
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(25989):\n",
    "        if(np.isnan(data_raw[i][3]) == True):\n",
    "            data_raw[i][3] = 0\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "id": "5ee70272",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['AFG', 'Afghanistan', 1949, ..., 0.002, 7624058.0, nan],\n",
       "       ['AFG', 'Afghanistan', 1950, ..., 0.011, 7752117.0, 9421400064.0],\n",
       "       ['AFG', 'Afghanistan', 1951, ..., 0.012, 7840151.0, 9692279808.0],\n",
       "       ...,\n",
       "       ['ZWE', 'Zimbabwe', 2018, ..., 0.821, 14438812.0, 22715353088.0],\n",
       "       ['ZWE', 'Zimbabwe', 2019, ..., 0.748, 14645473.0, nan],\n",
       "       ['ZWE', 'Zimbabwe', 2020, ..., 0.709, 14862927.0, nan]],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_raw"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 175,
   "id": "c4f57c4e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Asia\n",
      "Asia (excl. China & India)\n",
      "China\n",
      "Europe\n",
      "Europe (excl. EU-27)\n",
      "European Union (27)\n",
      "European Union (28)\n",
      "High-income countries\n",
      "Lower-middle-income countries\n",
      "North America\n",
      "United States\n",
      "Upper-middle-income countries\n",
      "World\n"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "id": "0e0ad84c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Europe\n",
      "European Union (27)\n",
      "European Union (28)\n",
      "High-income countries\n",
      "North America\n",
      "United States\n"
     ]
    }
   ],
   "source": [
    "#设定20世纪>100且 2000-2020>500为标准，输出满足条件国家\n",
    "for i in range(len(data_raw)):\n",
    "\n",
    "    if data_raw[i][2] == float(1900):\n",
    "        co2 = 0\n",
    "        for j in range(100):\n",
    "            co2 += data_raw[i+j][3];\n",
    "        if((co2 >100) &((data_raw[i+100][3] - data_raw[i+120][3]) > float(500))):\n",
    "           print(data_raw[i][1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d75f4ef3",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
